User's Own Session Details

Your rating: None Average: 1.5 (2 votes)

An SQL to find user's session's details from within his/her session.

SELECT * FROM v$session
WHERE sid = (SELECT sid FROM v$mystat
             WHERE rownum=1);

You can also use the SQL below if you are running on 10g or higher:
SELECT * FROM v$session
WHERE sid = sys_context('userenv','sid');

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!