发布时间：2014-10-10 09:34:20
#!/bin/bash
time=`date +%Y%m%d`
#echo "rman_backup_$time.log"
cat /home/oracle/logs/rman_backup_$time.log | mail -s "This is 141 rman logs" xuzhaowei@paypalm.cn......【阅读全文】
发布时间：2014-10-09 15:25:02
select a.owner Owner,
a.tablespace_name Tablespace,
a.segment_type Type,
a.segment_name Name,
ROUND(a.bytes / 1048676) "Size/M"
from dba_segments a
where a.owner not in
('SCOTT', 'ORACLE_OCM', 'XS$NULL', 'MDDATA', 'DIP',
'APEX_PUBLIC_USER', 'SPATIAL_CSW_ADMIN_USR', 'SPATIAL_WFS_ADMIN_USR',
'FLOWS_FILES', 'MDSYS', 'ORDSYS', 'EXFSYS', 'DBSNMP', 'WMSYS',
'APPQOSSYS', 'APEX_030200', 'OWBSYS_AUDIT', 'ORD......【阅读全文】
