gv$session show parallel events when I connect to RAC database
Hi masters,
1. Why sqlplus in RAC 11gR2 create 3 connections to the database with parallel events???
$ sqlplus admin
SQL> select username, inst_id,sid,serial#,event,ownerid
from gv$session
where AUDSID = userenv('SESSIONID') order by service_name;
USERNAME INST_ID SID SERIAL# EVENT OWNERID
------------------------------ ---------- ---------- ---------- ---------------------------------------------------------------- ----------
ADMIN 1 168 6941 PX Deq: Execute Reply 2147483644
ADMIN 1 402 27561 PX Deq: Execution Msg 65704
ADMIN 2 38 31075 PX Deq: Execution Msg 65704
2. If I query from another terminal and sysdba user, I see different user of this sid/serial!!! (SYS)
$ sqlplus / as sysdba SQL> select username, inst_id,sid,serial#,event,ownerid from gv$session where sid in(38,402,168); USERNAME INST_ID SID SERIAL# EVENT OWNERID ------------------------------ ---------- ---------- ---------- ---------------------------------------------------------------- ---------- ADMIN 1 168 6941 SQL*Net message from client 2147483644 SYS 1 402 27861 PX Deq: Execution Msg 65737 SYS 2 38 31759 PX Deq: Execution Msg 65737
0