oracle使用监控脚本_ck_tablespace.sh
#!/bin/sh
sqlplus $1/$2@$3 <
set lines 130
set pagesize 999
col TS_name format a13
col TS_place format a48
spool $4.txt
select b.file_id ID,b.FILE_NAME TS_place,b.tablespace_name TS_name,b.bytes BYTES,b.MAXBYTES,
(b.bytes-sum(nvl(a.bytes,0))) USED,sum(nvl(a.bytes,0)) surplus,
sum(nvl(a.bytes,0))/(b.bytes)*100 surplus_pre
from dba_free_space a,dba_data_files b
where a.file_id=b.file_id
group by b.tablespace_name,b.file_id,b.bytes,b.FILE_NAME,b.MAXBYTES
order by b.file_id;
spool off
exit
EOF
sqlplus $1/$2@$3 <
set lines 130
set pagesize 999
col TS_name format a13
col TS_place format a48
spool $4.txt
select b.file_id ID,b.FILE_NAME TS_place,b.tablespace_name TS_name,b.bytes BYTES,b.MAXBYTES,
(b.bytes-sum(nvl(a.bytes,0))) USED,sum(nvl(a.bytes,0)) surplus,
sum(nvl(a.bytes,0))/(b.bytes)*100 surplus_pre
from dba_free_space a,dba_data_files b
where a.file_id=b.file_id
group by b.tablespace_name,b.file_id,b.bytes,b.FILE_NAME,b.MAXBYTES
order by b.file_id;
spool off
exit
EOF
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8806316/viewspace-949574/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- oracle virtualbox修改虚拟机的default machine folder
- linux 脚本 for 与while实际中的区别
- linux下nc检测端口
- linux_命令行批量修改密码
- linux_vmware_openfiler_静默方式安装_ora10201_rac执行root.sh脚本报错libpthread.so.0不能打开处理
- linux_vsftpd登录后执行ls不显示文件列表
- linux_openfiler_udev配置
- rhel5.6_openfiler_oracle10gRAC_udev
- linux_ulimit_open filer
- linux下nc扫描tcp,udp端口
