-
编辑 删除
Rman Scripts (Linux)
---------------------------------------------------backup#!/bin/bash#Introduce: Linux backup Oracle by RMAN everyday.#2010/04/15 by Lihongyiecho 'Attention:Linux ready to backup Oracle now!'source $HOME/.bash_profilerman=$ORACLE_HOME/bin/rmanfilepath=`date +%Y%m%d`weekday=`date -d today +%w`mkdir /backup/"$filepath"if [ "$weekday" == "7" ]; thenrman target / <<EOFbackup incremental level=0 database format '/backup/$filepath/%U';delete expired backup;quit;EOFel
-
编辑 删除
Tuning Scripts
--查看所有用户下的monitor信息 SELECT u.name owner, io.name index_name, t.name table_name, decode(bitand(i.flags, 65536), 0, 'NO', 'YES') monitoring, decode(bitand(ou.flags, 1), 0, 'NO', 'YES') used, ou.start_monitoring start_monitoring, ou.end_monitoring end_monitoring FROM sys.user$ u, sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou WHERE i.obj# = ou.obj# AND io.obj# = ou.obj# AND t.obj# = i.bo# AND u.user# = io.owner#; --查看长时间运行会话的脚本 SELECT L.sid ssid, substr(OPNAME,1,15)
