SQl on GV$ stuck from PDB working on CDB (Doc ID 2763957.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

In the images, examples and document that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.

Queries against GV$ tables getting stuck from PDB

Sessions are waiting/hanging on 'PX Deq: Join ACK' and PPA* on 'PX Deq:

 Current Wait Stack:
    0: waiting for 'PX Deq: Join ACK'
       sleeptime/senderid=0x64, passes=0x1fe48, =0x0
       wait_id=58xxx seq_num=24xxx snap_id=65xxx
       wait times: snap=1.387450 sec, exc=2171 min 41 sec, total=2171 min 42 sec   <<< 2000+ EXEC
       wait times: max=infinite, heur=2171 min 42 sec
       wait counts: calls=65xxx os=65xxx
       in_wait=1 iflags=0x1xxx
...
 is waiting for 'PX Deq: Join ACK' with wait info:
  {
                     p1: 'sleeptime/senderid'=0xxx
                     p2: 'passes'=0x20xxx
           time in wait: 0.803814 sec (last interval)
           time in wait: 2185 min 23 sec (total)
...

         wait history:
             * time between current wait and wait #1: 0.000000 sec
             1.       event: 'PX Deq: reap credit'
                time waited: 0.000003 sec
                    wait id: 190xxx         
             * time between wait #1 and #2: 0.000000 sec
             2.       event: 'PX Deq: Join ACK'
                time waited: 1.001064 sec (last interval)
                time waited: 2185 min 22 sec (total)       <<<<<<<<<<<<<<<<<<<
                    wait id: 58xxx      p1: 'sleeptime/senderid'=0xxx
                                              p2: 'passes'=0x20xxx
             * time between wait #2 and #3: 0.000000 sec
             3.       event: 'PX Deq: reap credit'
                time waited: 0.000008 sec
                    wait id: 190xxx         

Changes

 NA

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.