Sessionid, When Oracle Updates Sessionid? Options

[thiyagusham]

Hi to all ;

SESSIONID , returns the auditing session identifier
am i right ?

my question is when oracle updating session id ?

SQL> show user;
USER is "SYS"

SQL> select sid,serial# from v$session where audsid=sys_context
2 ('userenv','sessionid');

SID SERIAL#
---------- ----------
170 10

SQL> select userenv('sessionid') from dual;

USERENV('SESSIONID')
--------------------
4294967295

objects not updated under sys user.
--
SQL> conn sams
Enter password:
Connected.
SQL> select userenv('sessionid') from dual;

USERENV('SESSIONID')
--
4950120

SQL> select userenv('sessionid') from dual;

USERENV('SESSIONID')
--
4950120


see sys user session_id shows 4294967295
sams user session_id 4950120
-
again i am connecting as sys user;

again i check session id -- > no changes 4294967295

now user sams connected

checking session id 4950121

--

hope till this you can understand ,

my question is
without any opertion under (sys ,sams) users
why sessionid updated under sams ?
why sessionid not updated under sys ?

--

Thanks in advance
Thiyagusham.G

[burleson]

http://www.dba-oracle.com/art_builder_sec_audit.htm