PX Deq: Slave Session Stats + PX Nsq: PQ load info query + IPC send completion sync waits
Hi,
One operation got aborted with error (ORA-01013: user requested cancel of current operation) and when AWR is generated for the aborted period, below wait events are present in top 5. Is the abort related with this? Can anyone help me in identifying it?
It is a RAC database on AIX-Based Systems (64-bit).
Event Waits Time(s) Avg wait (ms) % DB time Wait Class
DB CPU 102 29.02
PX Deq: Slave Session Stats 15,526 89 6 25.49 Other
PX Nsq: PQ load info query 359 41 116 11.86 Other
reliable message 1,621 20 13 5.85 Other
IPC send completion sync 59,710 19 0 5.50 Other
Thanks ,
Sriram Ganapathy
One operation got aborted with error (ORA-01013: user requested cancel of current operation) and when AWR is generated for the aborted period, below wait events are present in top 5. Is the abort related with this? Can anyone help me in identifying it?
It is a RAC database on AIX-Based Systems (64-bit).
Event Waits Time(s) Avg wait (ms) % DB time Wait Class
DB CPU 102 29.02
PX Deq: Slave Session Stats 15,526 89 6 25.49 Other
PX Nsq: PQ load info query 359 41 116 11.86 Other
reliable message 1,621 20 13 5.85 Other
IPC send completion sync 59,710 19 0 5.50 Other
Thanks ,
Sriram Ganapathy
0