Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How find out my session id?

436909Mar 17 2005 — edited Mar 17 2005
Hi,

what I would to do is to find out, from within PL/SQL, the session-id of my current session.

I understand that the session-id is the integer in the field "sid" in v$session.

Given, that the same program, may be running, on the same server, under the same user and perhaps even at the same time on different sessions, how can I identify "my own" current session id?

Thanks a lot in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2005
Added on Mar 17 2005
3 comments
849 views