Convert hexadecimal to decimal
I recently needed to do analyze a database for TM contention I was having in an Oracle database that I support. First, I had to obtain the hex value from the trace file generated by the deadlock in the oracle database : example: *** 2011-04-05 12:59:41.511 DEADLOCK DETECTED ( ORA-00060 ) [Transaction Deadlock] The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL. The following information may aid in determining the deadlock: Deadlock graph: ---------Blocker(s)-------- ---------Waiter(s)--------- Resource Name process session holds waits process session holds waits TM-000156cc-00000000 58 323 SX 129 499 ...