| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Current session information without parallel processes
Nope, but I'll be durned if I can repeat the situation. I logged in as an account with the DBA role, but not "AS SYSDBA". The query returned five rows. The first row was my actual process. The other four were the "P00x" parallel processes, with my username and audsid attached to them.
I've been messing with MVs using parallel to create them, but I'm not able to repeat the situation...
Rich
-----Original Message-----
Sent: Thursday, August 26, 2004 3:46 PM
Subject: RE: Current session information without parallel processes
Jesse,
>access to $ORACLE_HOME/udump). However, as I'm trying to run
>it, it's blowing up because multiple rows are returned from:
>SELECT vp.spid
> AND vs.audsid = sys_context('USERENV','SESSIONID');
I assume your testing involved a certain user named 'SYS' ;-) The reason is that all internal sessions as well as other sessions that connect as SYS will get a SESSIONID of 0. This is the reason for your multiple rows.
Not sure of your other question though - if you are using a logon trigger, just add the condition AUDSID != 0.
John Kanagaraj <><
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Aug 26 2004 - 16:26:16 CDT
 |
 |