22 lines
476 B
SQL
22 lines
476 B
SQL
prompt PARAMETERS
|
|
|
|
@pd "&1"
|
|
|
|
prompt STATS
|
|
select * from v$sysstat where lower(name) like lower('%&1%');
|
|
|
|
prompt EVENTS
|
|
select * from v$system_event where lower(event) like lower('%&1%');
|
|
|
|
prompt LATCHES
|
|
select name, gets, immediate_gets from v$latch where lower(name) like lower('%&1%');
|
|
|
|
prompt ENQUEUES
|
|
|
|
select name, expl descr from x$ksqeqtyp where lower(name) like lower('%&1%')
|
|
union
|
|
select name, expl from x$ksirestyp where lower(name) like lower('%&1%');
|
|
|
|
|
|
set feed on
|