- 论坛徽章:
- 0
|
[原创]16.监控oracle的表空间\r\n# mon_ts_space.sh\r\ncd /home/oraprod\r\nsqlplus \"/as sysdba\" <<EOF\r\nset feed off;\r\nset heading off;\r\nspool /tmp/mon_ts_space.out;\r\n@mon_ts_space.sql\r\nexit\r\nEOF\r\ncat /tmp/mon_ts_space.out|grep -v SQL|grep [0-9]|awk -f mon_ts_space.awk\r\n\r\n\r\n# mon_ts_space.sql\r\nselect\r\n df.tablespace_name \"Tablespace\",\r\n (df.totalspace - fs.freespace) \"Used MB\",\r\n fs.freespace \"Free MB\",\r\n df.totalspace \"Total MB\",\r\n round(100 * (fs.freespace / df.totalspace)) \"Pct. Free\"\r\nfrom\r\n dba_tablespaces ts,\r\n (select tablespace_name,\r\n round(sum(bytes) / 1048576) TotalSpace\r\n from dba_data_files\r\n group by tablespace_name) df,\r\n (select tablespace_name,\r\n round(sum(bytes) / 1048576) FreeSpace\r\n from dba_free_space\r\n group by tablespace_name) fs\r\nwhere\r\n ts.tablespace_name = fs.tablespace_name\r\nand\r\n df.tablespace_name = fs.tablespace_name(+) \r\nand \r\nround(100 * (fs.freespace / df.totalspace)) <20\r\nand df.tablespace_name not in (\'APPS_UNDOTS1\',\'TEMP\');\n\n[ 本帖最后由 mxin 于 2006-7-5 08:23 编辑 ] |
|