Database Reference
In-Depth Information
8 rows selected
SELECT NAME,
VALUE
FROM v$sysstat
WHERE UPPDER(NAME) LIKE '%PARALLEL OPERATIONS%'
OR UPPER(NAME) LIKE '%PARALLELIZED%'
OR UPPER(NAME) LIKE '%PX%';
NAME VALUE
----------------------------------- -----------
queries parallelized 129681
DML statements parallelized 110
DDL statements parallelized 2372
DFO trees parallelized 153353
Parallel operations not downgraded 151035
Parallel operations downgraded to s 34488
Parallel operations downgraded 75 t 156
Parallel operations downgraded 50 t 204
Parallel operations downgraded 25 t 116
Parallel operations downgraded 1 to 1842
PX local messages sent 82452573
PX local messages recv'd 82446792
PX remote messages sent 1611916
PX remote messages recv'd 1605765
SELECT px.inst_id INT,
DECODE(px.qcinst_id, NULL, username,
' - '
||LOWER(Substr(s.program, LENGTH(s.program) - 4, 4))
)
"Username",
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",
s.event "Wait Event"
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
/
Search WWH ::




Custom Search