/*Query Find Tablespace Free */
SELECT TABLESPACE_NAME, ROUND (SUM (BYTES) / POWER (2, 20)) FREE_MB
FROM (SELECT BYTES, TABLESPACE_NAME
FROM DBA_FREE_SPACE
WHERE TABLESPACE_NAME IN
('APPS_TS_TX_DATA',
'APPS_TS_TX_IDX',
'APPS_TS_SUMMARY',
'APPS_TS_INTERFACE',
'APPS_TS_NOLOGGING',
'APPS_TS_ARCHIVE'))
GROUP BY TABLESPACE_NAME;