Database DataWarehousing (MOSC)

MOSC Banner

PX Nsq: PQ load info query wait among Top

edited Nov 14, 2013 9:06PM in Database DataWarehousing (MOSC) 3 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center