Return to Snippet

Revision: 64284
at July 19, 2013 01:54 by ceduard0

Initial Code
select MACHINE,
 from V$SESSION 
where sid=(select sys_context('USERENV','SID') from dual);

Initial URL

Initial Description
To get more information of the current session use this: DESC V$SESSION.

Note: Your user need a  GRANT SELECT ON V_$SESSION TO username;

Initial Title
How to get MACHINE name, PROGRAM name, operative system USER and the USERNAME related to the current Oracle Database Session

Initial Tags

Initial Language