Aos que estao tentando me auxiliar talvez isso os ajude. Executei essa select.
/* */ SELECT A.tablespace_name tablespace_name, to_char(TRUNC(NVL(SUM(B.BYTES/1048576),0) / (A.BYTES/1048576),4)*100)||'%' pct_free, 100 - to_char(TRUNC(NVL(SUM(B.BYTES/1048576),0) / (A.BYTES/1048576),4)*100)||'%' pct_used, NVL(TRUNC(SUM(B.BYTES/1048576),2),0)||'MB' FREE_SPACE, TRUNC((A.BYTES/1048576)-NVL(SUM(B.BYTES/1048576),2),0)||'MB' USED_SPACE, TRUNC(A.BYTES/1048576,2)||'MB' FILE_SIZE, autoextensible, status FROM DBA_DATA_FILES A, DBA_FREE_SPACE B WHERE A.FILE_ID=B.FILE_ID (+) AND A.tablespace_name IN (select distinct tablespace_name from user_tablespaces) GROUP BY A.tablespace_name, A.file_name, A.bytes/1048576, autoextensible, status, A.BYTES UNION SELECT AA.tablespace_name, to_char(TRUNC(NVL(SUM(BB.BYTES/1048576),0) / (AA.BYTES/1048576),4)*100)||'%' pct_free, 100 - to_char(TRUNC(NVL(SUM(BB.BYTES/1048576),0) / (AA.BYTES/1048576),4)*100)||'%' pct_used, NVL(TRUNC(SUM(BB.BYTES/1048576),2),0)||'MB' FREE_SPACE, TRUNC((AA.BYTES/1048576)-NVL(SUM(BB.BYTES/1048576),2),0)||'MB' USED_SPACE, TRUNC(AA.BYTES/1048576,2)||'MB' FILE_SIZE, autoextensible, status FROM DBA_TEMP_FILES AA, DBA_FREE_SPACE BB WHERE AA.FILE_ID=BB.FILE_ID (+) GROUP BY AA.tablespace_name, AA.FILE_NAME, AA.BYTES/1048576, autoextensible, status, AA.BYTES; /* */ TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- EXAMPLE 31,75% 68,25% 31,75MB TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- 68MB 100MB YES AVAILABLE TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- SYSAUX 2,02% 97,98% 7,68MB TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- 372MB 380MB YES AVAILABLE TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- SYSTEM ,45% 99,55% 2,25MB TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- 487MB 490MB YES AVAILABLE TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- TEMP ,01% 99,99% 2,25MB TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- 11405MB 11408MB YES AVAILABLE TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- UNDOTBS1 98,68% 1,32% 814,18MB TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- 10MB 825MB YES AVAILABLE TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- USERS 99,98% ,02% 32764,56MB TABLESPACE_NAME PCT_FREE ------------------------------ ----------------------------------------- PCT_USED ----------------------------------------- FREE_SPACE ------------------------------------------ USED_SPACE ------------------------------------------ FILE_SIZE AUT STATUS ------------------------------------------ --- --------- 3MB 32767,98MB YES AVAILABLE 6 linhas selecionadas. [As partes desta mensagem que não continham texto foram removidas]
