phantom in ORACLE

#!/bin/bashfor SID in $(ps -fu oracle | grep pmon | grep -v grep | cut -d_ -f3- | sort); doexport ORACLE_SID=$SIDsource ~/.bash_profilerow=`sqlplus -silent '/ as sysdba' << EOSQLset pagesize 0 feedback off verify off heading off echo offsele

#!/bin/shwhile :domysql -uroot -p'12wsxCDE#' -e "select now();show full processlist\g;select b.trx_mysql_thread_id AS '被阻塞线程',b.trx_query AS '被阻塞SQL',c.trx_mysql_thread_id AS '阻塞线程',(UNIX_TIMESTAMP()-UNIX_TIMESTAMP(c.trx_started)) AS '阻塞时间'from infor

#!/bin/bashsource /home/oracle/.bash_profile#mail_list='zhxx@xx.net,[url=mailto:zhangxx@xx.net]zhangxx@xx.net,139xxxxxxxx@139.com,135xxxxxxxx@139.com'[/url]alert_log=/u01/app/oracle/diag/rdbms/orcl_p/orcl/trace/alert_orcl.logif [ ! -e /tmp/mo_alert.lo

#!/bin/bash#make environment variable effect!if [ -f ~/.bash_profile ] ;thensource ~/.bash_profile;fiif [ -f ~/.profile ] ;thensource ~/.profile;fiTMP_FILE=/tmp/`date +%Y%m%d`.txtsqlplus -s

SELECT S.SQL_TEXT, S.SQL_FULLTEXT, S.SQL_ID, ROUND(ELAPSED_TIME / 1000000 / (CASE WHEN (EXECUTIONS = 0 OR NVL(EXECUTIONS, 1 ) = 1) THEN 1

set lines 9999SELECT s.sid,s.serial#,s.machine,sl.opname,sl.target,sl.message,s.program,sl.sql_hash_value,TRUNC(sl.elapsed_seconds/60) || ':' || MOD(sl.elapsed_seconds,60) elapsed,TRUNC(sl.time_re

SELECT UPPER(F.TABLESPACE_NAME) "表空间名",D.TOT_GROOTTE_MB "表空间大小(M)",D.TOT_GROOTTE_MB - F.TOTAL_BYTES " 已使用空间(M)",TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) /D.TOT_GROOTTE_MB * 100, 2)

RMAN 配置信息：db\_unique\_name 为 RACDB 的数据库的 RMAN 配置参数为:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; \# default 保留一份备份CONFIGURE BACKUP OPTIMIZATION OFF; \# defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; \