摘要:
---以下是相关PROCEDURE:CREATE OR REPLACE PROCEDURE start_monitor_indexISCursor cur1 isselect OWNER,INDEX_NAME from dba_indexes di where di.owner like '%BJ';p_rows cur1%ROWTYPE;p_str varchar2(200);beginopen... 阅读全文
摘要:
select d.plan_hash_value plan_hash_value, d.execnt execnt, a.hash_value hash_value, a.sql_text sql_text from v$sqltext a, (select plan_hash_value, hash_va... 阅读全文
摘要:
select /*+ordered */ sql_text, spid, v$session.program, machine, process, sid, v$session.SERIAL# from v$process, v$session, v$sql where v$sql.address = v$session.sql_address and v$sql.hash_value =... 阅读全文
摘要:
SELECTTO_CHAR(first_time,'MM/DD') DAY--, TO_CHAR(first_time,'YYYY/MM/DD') DAY2, SUM(DECODE(TO_CHAR(first_time, 'HH24'),'00',1,0)) H00, SUM(DECODE(TO_CHAR(first_time, 'HH24'),'01',1,0)) H01, SUM(DECODE... 阅读全文
摘要:
select name, value from v$sysstat where name in ('table scans (short tables)', 'table scans (long tables)', 'index fast full scans (full)', 'index fast full scans (rowid ranges)',... 阅读全文
摘要:
select s.username username,s.serial# serial,se.sid,n.name, max(se.value) maxmemfrom v$sesstat se, v$statname n, v$session swhere n.statistic# = se.statistic#and s.sid=se.sidand s.usernam... 阅读全文
摘要:
select s.username,s.SID, u.name, r.RSSIZE, r.WRITES, r.HWMSIZE from v$transaction t, v$rollstat r, v$rollname u, v$session s where s.taddr = t.addr and t.xidusn = r.usn and r.usn = u.usn order by... 阅读全文
摘要:
select b.username, a.* from v$sess_io a, v$session b where a.sid in (select x.sid from v$session x where x.status = 'ACTIVE' and x.PADDR not in (select paddr from ... 阅读全文
摘要:
select p.spid, c.object_name, c.subobject_name, b.session_id, b.oracle_username, b.os_user_name from v$process p, v$session a, v$locked_object b, all_objects c where ... 阅读全文
摘要:
SQL> select u_dump.value || '/' || db_name.value || '_ora_' || v$process.spid || nvl2(v$process.traceid, '_' || v$process.traceid, null )|| '.trc' "Trace File" from v$parameter u_dump cross join v$par... 阅读全文