To find free space in oracle DB
Submitted by younus on Wed, 2019-07-17 04:57
articles:
SELECT tablespace_name ,round(TOTAL_SIZE,2) ,round(TOTAL_SIZE-FREE_SIZE,2) ,
round(FREE_SIZE,2)
FROM (SELECT tablespace_name,(SELECT SUM(BYTES)/1024/1024/1024 FROM DBA_DATA_FILES b WHERE b.TABLESPACE_NAME=a.TABLESPACE_NAME)TOTAL_SIZE,
SUM(bytes)/1024/1024/1024
FREE_SIZE
FROM DBA_FREE_SPACE a GROUP BY tablespace_name) order by 1;
»
- younus's blog
- Log in to post comments