Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

performance Tuning 10g reference poster
 
Oracle training in Linux 

commands
 
Oracle training 

Excel
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Closed TopicStart new topic
> Sessionid, When Oracle Updates Sessionid?
thiyagusham
post Apr 6 2012, 03:47 PM
Post #1


Advanced Member
***

Group: Members
Posts: 78
Joined: 16-March 12
From: Chennai from India
Member No.: 46,939



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
Go to the top of the page
 
+Quote Post
burleson
post Apr 6 2012, 04:39 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,087
Joined: 26-January 04
Member No.: 13



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


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 16th April 2014 - 11:11 AM