Tablespace occupation
Hi,
On 19c (19.7) on AIX
I run this query:
select tablespace_name, sum (bytes/1048576) TOTAL,
round(sum (user_bytes/1048576)) TOTAL_USER,round(100*(sum (user_bytes/1048576)/sum (bytes/1048576))) Pourcent_data
from dba_data_files where autoextensible='YES' group by tablespace_name having tablespace_name like '%AUDIT%';
TABLESPACE_NAME TOTAL TOTAL_USER POURCENT_DATA
------------------------------ ---------- ---------- ------ ------------------
TS_AUDIT_AUX 300 299 100
But Sql Devloper (Manage database) shows:
What is wrong with my query?
Thanks.