Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

trace from ORA-04020

branislav.dobrotkaApr 7 2010 — edited Apr 7 2010

HI all
db info :
9.2.0.8.0, System name: AIX

During night bath db generated ORA-04020 :
ORA-04020: deadlock detected while trying to lock object UCT.TMP_HGR_PU_O_201003_T17
--------------------------------------------------------
object waiting waiting blocking blocking
handle session lock mode session lock mode
-------- -------- -------- ---- -------- -------- ----
7000001221ecce8 70000011b28ba60 70000012edaed80 X 70000011c2f28c8 70000014a0f8560 S
7000001471248a0 70000011c2f28c8 700000121a36150 S 70000011b28ba60 700000121a35848 X

I would like to find session info (waiter/holder) ,.. etc: Can I translate 70000011b28ba60 ? is this hex number from wich info about session ?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2010

Added on Apr 7 2010

#general-database-discussions

7 comments

2,347 views