Skip to Main Content

Oracle Database Discussions

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!

v$session , sid , audsid

KramerDec 4 2011 — edited Dec 4 2011
Hi

Can anyone help to explain the difference between sid column and audsid please?

And below output also confuse me.
SQL> select sys_context('USERENV','SID') from dual;

SYS_CONTEXT('US
---------------
*243*

SQL> select sys_context('USERENV','SESSIONID') from dual;

SYS_CONTEXT('US
---------------
*239442131*
Aren`t they the same thing? sid and sessionid

Regards
Mingwei

Edited by: Kramer on 2011-12-4 下午6:55
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 1 2012
Added on Dec 4 2011
1 comment
4,868 views