6 lines
221 B
SQL
6 lines
221 B
SQL
prompt Display Latch stats from V$LATCH for latches matching %&1%
|
|
|
|
select addr, name, gets, misses, immediate_gets ig, immediate_misses im, spin_gets spingets, wait_time
|
|
from v$latch
|
|
where lower(name) like lower('%&1%');
|