... ctime, -- CTIME NUMBER block -- BLOCK NUMBER from
v$_lock1
union all
select
inst_id, -- INST_ID NUMBER ...
http://orasql.org/2012/06/30/a-lot-of-latch-free-dml-allocation-latch-in-concurrent-queries-to-vlock/
Similar Pages
... "V$_LOCK1"."LADDR" "LADDR",
"V$_LOCK1"."KADDR" "KADDR",
... "V$_LOCK1"."SADDR" "SADDR",
"V$_LOCK1"."RADDR" "RADDR",
... "V$_LOCK1"."LMODE" "LMODE",
"V$_LOCK1"."REQUEST" "REQUEST" ...
... "V$_LOCK1"."LADDR" "LADDR",
"V$_LOCK1"."KADDR" "KADDR",
... "V$_LOCK1"."SADDR" "SADDR",
"V$_LOCK1"."RADDR" "RADDR",
... "V$_LOCK1"."LMODE" "LMODE",
"V$_LOCK1"."REQUEST" "REQUEST" ...
... "V$_LOCK1"."LADDR" "LADDR",
"V$_LOCK1"."KADDR" "KADDR",
... "V$_LOCK1"."SADDR" "SADDR",
"V$_LOCK1"."RADDR" "RADDR",
... "V$_LOCK1"."LMODE" "LMODE",
"V$_LOCK1"."REQUEST" "REQUEST" ...
... "V$_LOCK1"."LADDR" "LADDR",
"V$_LOCK1"."KADDR" "KADDR",
... "V$_LOCK1"."SADDR" "SADDR",
"V$_LOCK1"."RADDR" "RADDR",
... "V$_LOCK1"."LMODE" "LMODE",
"V$_LOCK1"."REQUEST" "REQUEST" ...
http://www.akadia.com/download/documents/show_blocking_sessions.sql
Similar Pages
... TER from V$LOCK L_WAITER, V$LOCK L_LOCKER, V$SESSION S_WAITER, V$SESSION S_LOCKER, V$_LOCK1 L1_WAITER ... REQUEST)) SQL_TEXT_WAITER from V$LOCK L_WAITER, V$LOCK L_LOCKER, V$SESSION S_WAITER, V$SESSION S_LOCKER, OBJ$ ... L1_WAITER, V$OPEN_CURSOR O where S_WAITER.SID = L_WAITER.SID and L_WAITER.TYPE IN ('TX') and S_LOCKER.sid = L_LOCKER ...
... ctime, -- CTIME NUMBER block -- BLOCK NUMBER from
v$_lock1
union all
select
inst_id, -- INST_ID NUMBER ...
... latch_children v $ _lock1 v $ enqueue_statistics v$enqueue_lock v$latch_misses ... v$_lock1
v$enqueue_statistics ... dictionary V $ Views: [SQL] v $ access v $ sga v $ buffer_pool v $ sgastat v $ buffer_pool_statistics v $ s ...
http://jonathanlewis.wordpress.com/2013/05/02/vlock/?replytocom%3D55175#
Similar Pages
... | |
| 5 | VIEW | GV$_LOCK1 | 2 |
| 6 | UNION-ALL | ... | |
| 6 | VIEW | GV$_LOCK1 | 2 |
| 7 | UNION-ALL | ... v$lock | Oracle Scratchpad Oracle Scratchpad May 2, 2013 v$lock Filed under: Locks,Oracle,Statistics ...
http://jonathanlewis.wordpress.com/2013/05/02/vlock/?replytocom%3D55175
Similar Pages
... | |
| 5 | VIEW | GV$_LOCK1 | 2 |
| 6 | UNION-ALL | ... | |
| 6 | VIEW | GV$_LOCK1 | 2 |
| 7 | UNION-ALL | ... v$lock | Oracle Scratchpad Oracle Scratchpad May 2, 2013 v$lock Filed under: Locks,Oracle,Statistics ...