Description: Why going for large scripts?
--This script shows available space,used space, free space and its percentage values. Tablespaces which are 100% free are not listed.
--Code:
SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED,C.BYTES FREE,round((B.BYTES*100)/A.BYTES) "% USED",round((C.BYTES*100)/A.BYTES) "% FREE"
FROM SYS.SM$TS_AVAIL A, SYS.SM$TS_USED B, SYS.SM$TS_FREE C
WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.TABLESPACE_NAME=C.TABLESPACE_NAME;
Discuss about the Freespace on tablespace you can reach out on 9966775883
--This script shows available space,used space, free space and its percentage values. Tablespaces which are 100% free are not listed.
--Code:
SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED,C.BYTES FREE,round((B.BYTES*100)/A.BYTES) "% USED",round((C.BYTES*100)/A.BYTES) "% FREE"
FROM SYS.SM$TS_AVAIL A, SYS.SM$TS_USED B, SYS.SM$TS_FREE C
WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.TABLESPACE_NAME=C.TABLESPACE_NAME;
Discuss about the Freespace on tablespace you can reach out on 9966775883
No comments :
Post a Comment