select file#,
block#,
status,
xnc,
p.forced_reads,
p.forced_writes,
name,
partition_name,
kind,
owner#,
p.lock_element_addr,
p.lock_element_name,
p.class# lock_element_class
from v$ping p, v$locks_with_collisions c
where (p.forced_reads + p.forced_writes) > 5
and p.lock_element_addr = c.lock_element_addr
SELECT FILE#
,
BLOCK#
,
STATUS
,
XNC
,
P.FORCED_READS
,
P.FORCED_WRITES
,
NAME
,
PARTITION_NAME
,
KIND
,
OWNER#
,
P.LOCK_ELEMENT_ADDR
,
P.LOCK_ELEMENT_NAME
,
P.CLASS# LOCK_ELEMENT_CLASS
FROM V$PING P
, V$LOCKS_WITH_COLLISIONS C
WHERE (P.FORCED_READS + P.FORCED_WRITES) > 5
AND P.LOCK_ELEMENT_ADDR = C.LOCK_ELEMENT_ADDR
|
|
|