Identify the root cause of a enq: TX
Hi,
We hvae been an issue with a process that hung and generate an enq TX, this process run like a JOB (Scheduler JOB) on a 10.2.0.4 database. Up to day we use an 10046 trace in order to diag it but i am looking for new aproachs that can be used by my development tema.
With the values of row_wait_obj#, row_wait_file#, row_wait_block#, row_wait_row# from the v$session I got the ROWID of the row that is causing the enq. My problem is that the ROWID correspond to an INDEX and i do not know how can I access the table rows that correspond to an INDEX rowid. Can any one help me?.
We hvae been an issue with a process that hung and generate an enq TX, this process run like a JOB (Scheduler JOB) on a 10.2.0.4 database. Up to day we use an 10046 trace in order to diag it but i am looking for new aproachs that can be used by my development tema.
With the values of row_wait_obj#, row_wait_file#, row_wait_block#, row_wait_row# from the v$session I got the ROWID of the row that is causing the enq. My problem is that the ROWID correspond to an INDEX and i do not know how can I access the table rows that correspond to an INDEX rowid. Can any one help me?.
0