cronjob 监控脚本
东方-phantom
Oracle 爱游泳 爱音乐电影
展开
-
Oracle dataguard 主备同步检测脚本
#!/bin/bash for SID in $(ps -fu oracle | grep pmon | grep -v grep | cut -d_ -f3- | sort); do export ORACLE_SID=$SID source ~/.bash_profile row=`sqlplus -silent '/ as sysdba' << EOSQL set pagesize 0 feedback off verify off heading off echo off sele原创 2020-12-26 21:25:09 · 395 阅读 · 0 评论 -
mysql 阻塞监控脚本
#!/bin/sh while : do mysql -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原创 2020-11-17 16:31:44 · 232 阅读 · 0 评论 -
mo_alert log监控
#!/bin/bash source /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.log if [ ! -e /tmp/mo_alert.lo原创 2020-10-16 16:19:14 · 132 阅读 · 0 评论 -
Oracle 清理udump垃圾文件shell
#!/bin/bash #make environment variable effect! if [ -f ~/.bash_profile ] ; then source ~/.bash_profile; fi if [ -f ~/.profile ] ; then source ~/.profile; fiTMP_FILE=/tmp/`date +%Y%m%d`.txt sqlplus -s原创 2016-06-24 09:59:14 · 1708 阅读 · 3 评论 -
Oracle查看耗资源SQL
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转载 2016-06-22 10:59:14 · 928 阅读 · 0 评论 -
Oracle查看会话剩余时间
set lines 9999 SELECT 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转载 2016-06-22 11:03:08 · 2418 阅读 · 0 评论 -
表空间使用率脚本
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)原创 2016-04-27 18:01:35 · 349 阅读 · 0 评论 -
Rman 备份脚本全
RMAN 配置信息:db\_unique\_name 为 RACDB 的数据库的 RMAN 配置参数为: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; \# default 保留一份备份 CONFIGURE BACKUP OPTIMIZATION OFF; \# default CONFIGURE DEFAULT DEVICE TYPE TO DISK; \转载 2017-08-07 09:09:35 · 1656 阅读 · 0 评论