oracle 表空间查看脚本
发布时间:2020-12-12 15:40:05 所属栏目:百科 来源:网络整理
导读:#!/bin/bash echo -e "nn*********~~~~~~~~~~~~~~~~~~~~~~~~~~~~DATE:" `date '+%Y/%m/%d %T'` "~~~~~~~~~~~~~~~~~~~~~~~*********" /home/oracle/tablespace.log export PATH=/opt/oracle/1102/db01/bin:$PATH export ORACLE_HOME=/opt/oracle/1102/db01/
#!/bin/bash echo -e "nn*********~~~~~~~~~~~~~~~~~~~~~~~~~~~~DATE:" `date '+%Y/%m/%d %T'` "~~~~~~~~~~~~~~~~~~~~~~~*********" >>/home/oracle/tablespace.log export PATH=/opt/oracle/1102/db01/bin:$PATH export ORACLE_HOME=/opt/oracle/1102/db01/ sqlplus -S /nolog <<eof conn xx/xx@orcl spool /home/oracle/tablespace.log append set line 200; set feedback off; set pagesize 50000; col member for a45; select a.tablespace_name,a.summary,b.free,b.maxf "MAX_FREE_EXTENT",b.free_exts "FREE_EXTENTS", 100-b.free/a.summary*100 "USED%" from (select tablespace_name,sum(bytes/1024/1024) "SUMMARY" from dba_data_files group by tablespace_name) a, (select tablespace_name,sum(bytes/1024/1024) "FREE",max(bytes/1024/1024) "MAXF",count(*) free_exts from dba_free_space group by tablespace_name) b where a.tablespace_name=b.tablespace_name order by 6 desc; --col SQL_TEXT for a50 --select t.SQL_TEXT,t.VERSION_COUNT,t.SHARABLE_MEM from v$sqlarea t where t.VERSION_COUNT>6; spool off; eof df -m >>/home/oracle/tablespace.log exit; ###################################################### 将上述内容保存到/tmp/tablespace.sh中 然后通过crontab -l -u oracle命令新建计划任务如下: 1 * * * * /bin/bash tmp/tablespace.sh 则每小时将会执行一次脚本,结果将会保存到home/oracle/tablespace.log中 ###################################################### 以上为在redhat6.4中验证 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |