PX Nsq: PQ load info query wait among Top
Hi,
Database is 11.2.0.3.8. 2 node RAC. Node-1 statspack Top 5 Timed Events has "PX Nsq: PQ load info query" wait among Top.
Can some one tell about this wait and why it has come. How to eliminate it. Does it cause database performance issue. We dont use parallel queries nor stream in our env.
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ----------- ----------- ------ ------
CPU time 385 44.7
PX Nsq: PQ load info query 1,231 240 195 27.9
Streams AQ: qmn coordinator waiting for s 7 43 6193 5.0
control file sequential read 15,987 32 2 3.7
direct path read 3,218 28 9 3.3
------------------------------------------------------------------------------------
Raj
Database is 11.2.0.3.8. 2 node RAC. Node-1 statspack Top 5 Timed Events has "PX Nsq: PQ load info query" wait among Top.
Can some one tell about this wait and why it has come. How to eliminate it. Does it cause database performance issue. We dont use parallel queries nor stream in our env.
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ----------- ----------- ------ ------
CPU time 385 44.7
PX Nsq: PQ load info query 1,231 240 195 27.9
Streams AQ: qmn coordinator waiting for s 7 43 6193 5.0
control file sequential read 15,987 32 2 3.7
direct path read 3,218 28 9 3.3
------------------------------------------------------------------------------------
Raj
0