| v$session entries. [message #104100] |
Thu, 29 July 2004 04:11  |
Udaya Shankar
Messages: 7
Registered: July 2004
|
Junior Member |
|
|
|
when can multiple sids have the same audsid ? Is it possible that a query that is executed in parallel, results in the creation of other sessions that share the same audsid of the parent session.
|
|
|
|
| Re: v$session entries. [message #104164 is a reply to message #104100] |
Mon, 09 August 2004 06:43  |
Stephane Vanhoecke
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
I have also a question about AUDSID and V$SESSION.
The function above return sometimes an error because the select on V$SESSION return more than 1 row.
How it's possible ?
(This function is not run as sys)
CREATE or REPLACE FUNCTION READ_SESSIONID
RETURN NUMBER IS
vSID varchar2(10);
BEGIN
select sid
into vSID
from sys.v$session
where audsid = sys_context('USERENV','SESSIONID');
return vSID;
END;
/
|
|
|
|
| Re: v$session entries. [message #104167 is a reply to message #104164] |
Mon, 09 August 2004 23:39 |
Udaya Shankar
Messages: 7
Registered: July 2004
|
Junior Member |
|
|
That could be because at the time the session could be performing an operation using the parallel clause in which case all the corresponding child sessions will also have the same audsid.
Hope the above helps.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
