Which the data that I obtain of view DUAL?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Which the data that I obtain of view DUAL?

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Cool Which the data that I obtain of view DUAL?

    I am in a company who 50% of the employees if connect by
    application server, being thus view v$session does not show who
    are loggged.
    View dual brings this information, does not remember as to make
    to remove this information.
    Who can help me?
    Tanks.
    Last edited by hhbrazil; 05-23-2003 at 10:08 AM.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: Which the data that I obtain to remove of view DUAL?

    Originally posted by hhbrazil
    Tanks.
    So you going to give tanks to those who help If im not mistaken you are asking how to view users session created through application server right ??
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114
    More or but this, I know that the dual shows of terminal/machine
    the user has connected... I need of this information

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Use sys_context function.

    example...

    select sys_context('USERENV','OS_USER') from dual;
    select sys_context('USERENV','IP_ADDRESS') from dual;
    select sys_context('USERENV','TERMINAL') from dual;

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    OMG so much info in a single row single column table??
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Obviously NOT normalised!

  7. #7
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Oh great!

    tank you a lot... Mr adewri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width