User's Own Session Details

Tue, 02/05/2008 - 6:45pm — Lepa

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');

Bookmark/Search this post with

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!

Comments

Have a question? Please ask it on the forum instead.

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Allowed HTML tags: <div> <pre> <br> <code> <a> <em> <blockquote> <strong> <ul> <ol> <li> <dl> <dt> <b> <p> <h1> <h2> <u> <img>
Web page addresses and e-mail addresses turn into links automatically.
Lines and paragraphs break automatically.
You can enable syntax highlighting of source code with the following tags: <code>. The supported tag styles are: <foo>, [foo].

BBcode

Notify me when new comments are posted

CAPTCHA

The question below is to prevent automated spam submissions.

What code is in the image?: *

Enter the characters shown in the image.

Title	Under	Posted on
MD5 - SHA checksum of a file.	PeopleSoft Technical	02/07/2012 - 5:29am
nVision Tabular Report through PIA with prompts	PeopleSoft Technical	02/02/2012 - 10:07pm
Can we create an AE to mass update Position - Jobcode data?	PeopleSoft Technical	01/18/2012 - 3:11am
Pay Components on job data can be defaulted and setup based on the rules?	PeopleSoft Functional	01/05/2012 - 4:58am