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

PostgreSQL Pgbadger Installation On Linux

PostgreSQL Sequence

Postgresql maximum size

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?