Re: Enqueue Wait Events - TM - SSX

<oraklee_at_gmail.com> wrote in message
news:1138242384.441004.81110_at_f14g2000cwb.googlegroups.com...
> Good day,
>
> We have 3-node Oracle 9.2.0.5 RAC database on AIX 5.2.
>
> Furthermore, we have captured the running statement and its waiting
> state by querying V$SESSION and V$SESSION_WAIT (and v$sql +
> dba_objects):
> Lo Mode OBJECT_NAME (WAIT_SECS) SQL_TEXT
> -- ----- -------------- ----------------------------------------
> TM 5 BWPHO_PK (3) DELETE BORROWER WHERE BORROWERKEY = :B1
> TM 5 BWPHO_BORRW_FK (2) DELETE BORROWER WHERE BORROWERKEY = :B1
>
> Lo == Lock Type
> Mode == Requested Lock Mode (5 == SSX or Sub Shared Exclusive)
> OJBECT_NAME == ROW_WAIT_OBJ# (obj associated with locked resource)
> WAIT_SECS == seconds in wait state
> SQL_TEXT == sql statement
>

Are any of these tables IOT ?

Can you supply the text of the query you are using to determine the object name.

Is th BWPHO_BORRW_FK an index on the borrower table, or on another table.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 10th Jan 2006