You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cannot recover from high SYSAUX usage in Free Autonomous Database

in Autonomous Database 6 comments

Summary:

Hi Keith,

I believe I have the same issue as has previously been discussed here with 7.5GB of unreclaimable SYSAUX.

Can you help with how to recover (cf. details below)?

Thanks,
Robert


Content (please ensure you mask any confidential information):

I ran the suggested queries with the following outputs:select max_size/1024/1024/1024, total_size/1024/1024 from v$pdbs;MAX_SIZE/1024/1024/1024    TOTAL_SIZE/1024/102420    27765

select tablespace_name, round(sum(bytes)/1024/1024/1024,2) as bytes_gb from dba_temp_files group by rollup(tablespace_name) order by 1;TABLESPACE_NAME    BYTES_GBTEMP    2    2

select tablespace_name, round(sum(bytes)/1024/1024,2) as bytes_mb from dba_data_files group by rollup(tablespace_name) order by 1;TABLESPACE_NAME    BYTES_MBDATA    13412DBFS_DATA    2148SAMPLESCHEMA    204800

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!