Re: Object lock identification

On Wed, 02 Jul 2003 15:54:20 GMT, "Kenneth A Kauffman" <kkauffman_at_nospam.headfog.com> wrote:

>In a nutshell, I have object locking occurring from what appears to be a bad
>application design and would like to identify specific values that are
>trying to be inserted.
>
>By doing the following:
>
>select * from v$lock;
>SELECT object_name FROM dba_objects WHERE
>object_id=<objectID(s)_from_above_query>;
>
>I can identify the rowids/blocks of the table objects that are locking.
>However, in the .trc file I see the reference to the objects:
>
>Session 79: obj - rowid = 00006102 - AAAAAAAAIAAAbrMAAA
>(dictionary objn - 24834, file - 8, block - 113356, slot - 0)
>Session 81: obj - rowid = 00006102 - AAAAAAAAIAAAbrMAAA
>(dictionary objn - 24834, file - 8, block - 113356, slot - 0)
>
>What I would like to know is how do I identify the values that are trying to
>be inserted/deleted into the common row? ... or is this possible?
>
>ken k
>

in 8.0 and higher you'll need to *data*_object_id in dba_objects. Also you can translate the rowid back to the file/record/block rowid by using the dbms_rowid package.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 02 2003 - 12:35:48 CDT