Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Enqueue Wait Events - TM - SSX

Re: Enqueue Wait Events - TM - SSX

From: Kevin <oraklee_at_gmail.com>
Date: 26 Jan 2006 15:18:27 -0800
Message-ID: <1138317507.013260.293470@z14g2000cwz.googlegroups.com>


> Are any of these tables IOT ? NO
> BWPHO_BORRW_FK is an index on BORROWERPHONE table. This is the child table to BORROWER.
> Here is the query to get the object name
set feed off
set head off
set trimspool on
set linesize 200
col Time format a9
col username format a8
col mode format a5
col sql_text format a60 wrap
col machine format a14
col object_name format a20

SELECT to_char(sysdate,'HH24:MI:SS') "Time",

        s.username,
        s.sid,
        chr(bitand(sw.p1,-16777216)/16777215)||
        chr(bitand(sw.p1, 16711680)/65535) "Lock",
        to_char( bitand(sw.p1, 65535) ) "Mode",
        o.object_name,
        sw.seconds_in_wait wait_secs,
        s.sql_hash_value,
        sql.sql_text
FROM v$session_wait sw,
     v$session s,
     v$sql sql,
     dba_objects o

where sw.sid = s.sid
and sw.sid > 7
and event != 'client message'
and wait_time = 0
and event not like '%NET%'
and event not like '%Net%'
and event = 'enqueue'
and sql.hash_value = s.SQL_HASH_VALUE
and o.object_id = ROW_WAIT_OBJ#
order by sw.sid, sw.event; Received on Thu Jan 26 2006 - 17:18:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US