Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

What is consuming space within my sysaux tablespace ?

The sysaux tablespace stores all of the AWR report information, snapshots that are taken and stored within the sysaux tableapace.
You can use the following scripts to display tablespace contents.  In the sysaux tablespace, the most common remedy is to purge older AWR information that is not longer needed.
Some AWR data you will want to keep for long periods f time, while more transient tables (SQL statement and plans, lock and match details) can be periodically truncated from the sysaux tablespace.

See here purging AWR data to free-up space in the sysaux tablespace.

Comments

Popular posts from this blog

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL pgBadger

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL Pgbadger Installation On Linux

Migrating From Oracle to PostgreSQL using ora2pg open source tools