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

rman interview and scenario based questions and answer and also rman(backup and recovery) discussions panel

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

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

PostgreSQL pgBadger