SQL> select tablespace_name,round(sum(bytes)/1024/1024) free_space_mb from dba_free_space group by (TABLESPACE_NAME);
TABLESPACE_NAME FREE_SPACE_MB
------------------------------ -------------
CWMLITE 24
DW_DERIVED_TBS 100
TS_SIM_X 50
OPMOR 1
IAS_META 35
WCRSYS_TS 1
DW_BASE_IDX 100
APPS_TS_QUEUES 651
OWAPUB 10
DW_DM_TBS 100
SYSAUX 126
TABLESPACE_NAME FREE_SPACE_MB
------------------------------ ------------
DSGATEWAY_TAB 2
DISCO_PTM5_META 1
B2B_DT 11
RE 1
TS_SALES_DATA_ENGINE_X 50
TS_SALES_DATA_ENGINE 50
DISCO_PTM5_CACHE 17
APPS_TS_ARCHIVE 201
APPS_CALCLIP 1544
BAM 2
APPS_TS_NOLOGGING 279
No comments:
Post a Comment