Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Enqueue Wait Events - TM - SSX
> 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
![]() |
![]() |