Parallel Query Tuning - Expert Oracle RAC Performance Diagnostics and Tuning - page 240

decode(px.qcinst_id,NULL, 'QC', '(Slave)') "QC/Slave" ,
to_char( px.server_set) "Slave Set",
to_char(s.sid) "SID",
decode(px.qcinst_id, NULL ,to_char(s.sid) ,px.qcsid) "QC SID",
px.req_degree "Requested DOP",
px.degree "Actual DOP",
px.qcinst_id "QC Inst"
from
gv$px_session px,
gv$session s
where
px.inst_id = s.inst_id
and
px.sid=s.sid (+)
and
px.serial#=s.serial#
and
username not in ('SYSTEM')
order by 6,2 desc
/
INT Username QC/Slave QC SID Requested DOP Actual DOP
---- ----------- ---------- ------ ------------- -----------
1 TPCC QC 745
3 - p004 (Slave) 745 8 8
2 - p002 (Slave) 745 8 8
1 - p004 (Slave) 745 8 8
2 - p000 (Slave) 745 8 8
3 - p005 (Slave) 745 8 8
2 - p003 (Slave) 745 8 8
3 - p000 (Slave) 745 8 8
1 - p005 (Slave) 745 8 8
2 - p001 (Slave) 745 8 8
2 - p004 (Slave) 745 8 8
1 - p000 (Slave) 745 8 8
3 - p001 (Slave) 745 8 8
3 - p002 (Slave) 745 8 8
2 - p005 (Slave) 745 8 8
1 - p001 (Slave) 745 8 8
3 - p003 (Slave) 745 8 8
1 - p002 (Slave) 745 8 8
1 - p003 (Slave) 745 8 8
The Oracle background processes are identified by the ora_p nnn where n indicates the number of the parallel
execution servers started. The following output lists 8 parallel processes started on instance one ( SSKYPRD_1 ) in a RAC
environment:
oracle 22591 1 24 19:36 ? 00:00:07 ora_p000_SSKYPRD_1
oracle 22593 1 26 19:36 ? 00:00:07 ora_p001_SSKYPRD_1
oracle 22595 1 25 19:36 ? 00:00:07 ora_p002_SSKYPRD_1
oracle 22597 1 24 19:36 ? 00:00:07 ora_p003_SSKYPRD_1