Hi,
DB and OS: 11.2.0.2 RAC on AIX 7.1
We have Global enqueues occurs every day and we are unable to find the reason for this. Application group is in analysis and from DB side, i would like to know, how can we identify the OBJECT_ID of the blocking session?.
I tried to convert hexadecimal 0x1ed0002 to decimal 32309250 but, there is no object in DB with the object_id=32309250. So, please suggest me how can i get the OBJECT_ID from the below WFG.
Global blockers dump end:-----------------------------------
Global Wait-For-Graph(WFG) at ddTS[0.fd4035] :
BLOCKED 0x7000004326b3ec0 3 wq 2 cvtops x1 TX 0x1ed0002.0x1a0120(ext 0x7,0x0)[2025-0254-000174DE] inst 2
BLOCKER 0x7000004326b3d00 3 wq 1 cvtops x28 TX 0x1ed0002.0x1a0120(ext 0x7,0x0)[2017-0176-00080DEC] inst 2
BLOCKED 0x700000431e32778 3 wq 2 cvtops x1 TX 0x1d5000f.0x800be(ext 0x7,0x0)[2017-0176-00080DEC] inst 2
BLOCKER 0x700000431e325b8 3 wq 1 cvtops x28 TX 0x1d5000f.0x800be(ext 0x7,0x0)[2025-0254-000174DE] inst 2
Thanks a lot,
Regards,