-
编辑 删除
Query undo ts use
--Query undo ts useSELECT TO_CHAR(s.sid) || ',' || TO_CHAR(s.serial#) AS sid_serial, NVL(s.username, '(oracle)') AS username, s.program, r.name undoseg, t.used_ublk * TO_NUMBER(x.value) / 102...
-
编辑 删除
Query temp ts use
--Query temp ts useSELECT b.tablespace, ROUND(((b.blocks * p.value) / 1024 / 1024), 2) || 'M' AS temp_size, a.sid || ',' || a.serial# AS sid_serial, NVL(a.username, '(oracle)') AS username, a...
-
编辑 删除
等待事件脚本
SELECT t1.sid, t1.serial#, t1.machine, t1.username, t1.event, t2.sql_text, t1.sql_id, t1.seconds_in_wait, ...
-
编辑 删除
Query lock table 脚本
select oracle_username, object_name, decode(a.locked_mode, 0,'None', /* Mon Lock equivalent */ 1,'Null', /* N */ ...
-
编辑 删除
rman_trun_arch.sh
<span style="font-family:宋体;line-height:normal;orphans:2;text-align:-webkit-auto;white-space:normal;widows:2;font-size:medium;"><br />#!/bin/bash</span><br style="font-family:宋体;line-height:normal;orphans:2;text-align:-webkit-auto;white-space:normal;widows:2;font-size:medium;" /><span style="f...
-
编辑 删除
archive_log_size_group_by_day
--每天产生的archive_log_sizeselect trunc(completion_time), sum(G)
-
编辑 删除
redo_log_switch_date
select sequence#, to_char(first_time, 'yyyy-mm-dd hh24:mi') || ' ' || to_char(nexttime, 'hh24:mi'), round(((first_time - nexttime) * 24) * 60, 2) diff from (select sequence#, ...
