Node Name Filespace FSID Platform Filespace Is Files- Capacity Pct Name Type pace Util Unicode? --------------- ----------- ---- -------- --------- --------- ----------- ----- QSDB /oradata 1 AIX JFS2 No 700 GB 38.4 QSDB_ORA /qsdb_ora 2 TDP Ora- API:ORAC- No 0 KB 0.0 cle AIX LE WFTBAK \wftbak\d$ 1 WinNT NTFS Yes 228 GB 18.0 ZHDB_ORA /zhdb_ora 2 TDP Ora- API:ORAC- No 0 KB 0.0 cle AIX LE
-- 基于filespce进行统计 tsm: WFTBAK>select sum(file_size)/1024/1024/1024 as total_size_gb \ cont> from backups, contents \ cont> where backups.object_id = contents.object_id \ cont> and backups.backup_date between '2014-04-13' and '2014-04-14' \ cont> and backups.filespace_name = '/qsdb_ora'
TOTAL_SIZE_GB --------------------- 2
tsm: WFTBAK>select backups.filespace_name, sum(file_size)/1024/1024/1024 as total_size_gb \ cont> from backups, contents \ cont> where backups.object_id = contents.object_id \ cont> and backups.backup_date between '2014-04-13' and '2014-04-14' \ cont> group by backups.filespace_name