SQl on GV$ stuck from PDB working on CDB
(Doc ID 2763957.1)
Last updated on NOVEMBER 04, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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
is waiting for 'PX Deq: Join ACK' with wait info:
time in wait: 0.803814 sec (last interval)
time in wait: 2185 min 23 sec (total)
* 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
* time between wait #2 and #3: 0.000000 sec
3. event: 'PX Deq: reap credit'
time waited: 0.000008 sec
wait id: 190xxx
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document