Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center