这个脚本可以监控tablespace 空间增长趋势,并且邮件通知到相关domain– 根据TOAD SPACE MANAGEMENT 修改
创建schema,tablespace,table:
create tablespace toad '+ARCH/data/tbs_ts[......]
January 10, 2013 maintain, oracle No comments scripts
这个脚本可以监控tablespace 空间增长趋势,并且邮件通知到相关domain– 根据TOAD SPACE MANAGEMENT 修改
创建schema,tablespace,table:
create tablespace toad '+ARCH/data/tbs_ts[......]
Scripts:dbms_backup_restore_dbid
eg:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Par[......]
August 10, 2012 maintain, oracle No comments scripts
11g之前还不支持分区自动interval day 功能,对于需要指定日期的分区需求例如每周2一个分区,可以采用下面脚本实现
select 'alter table END_USER_LOGIN_LOG_1 add partition P'|| TO_CHAR[......]
July 7, 2012 maintain, oracle No comments scripts
this scripts is used to monitor transaction rolling back progress
——————————————————————————-[……]
June 14, 2012 maintain, oracle No comments scripts
this scripts is used to check user all privileges
set serveroutput on;
DECLARE
v_user VARCHAR2(30) := ‘XXX’;
v_ddl[……]
April 20, 2012 Internals, oracle No comments scripts
Execution Environment:
Access Privileges:
Requires to be run connected as SYS schema
Usage:
$ sqlplus
SQL*Plus: Release 9.2.0.2.[……]
March 2, 2012 maintain, oracle No comments scripts
This script is monitoring sessions that are not commited :
— |—————————————————————————-|[……]
February 10, 2012 Internals, oracle No comments scripts
set echo off
————————————————–
— @name: lock_internal
— @author: dion cho
— @description: my own version of[……]
January 16, 2012 maintain, oracle No comments scripts
修改过的show_space 支持ASSM
create or replace
procedure show_space
( p_segname_1 in varchar2,
p_space in varchar2 def[……]
January 9, 2012 maintain, oracle No comments scripts
Alter session set sql_trace=true;
Alter session set STATISTICS_LEVEL = ALL;
set echo off verify off termout off
set doc off
doc
— ———-[……]