If tablespace sysaux is rapidly growing
Sometimes, expecially for new databases, DBAs can face with a rapidly growing SYSAUX tablespace. In most of the cases this is due to AWR snapshot information, so you should adjust SYSAUX space in order to keep it. Typically a size between 500MB and 1GB should be adequate, because AWR snapshot space is reused based on the AWR retention time (default: 7 days), and AWR creates a snapshot with a specified frequency (default: every hour): SQL> SELECT RETENTION FROM DBA_HIST_WR_CONTROL; RETENTION ————————————————————————— +00007 00:00:00.0 SQL> SELECT SNAP_INTERVAL FROM DBA_HIST_WR_CONTROL; SNAP_INTERVAL ————————————————————————— +00000 01:00:00.0 You can modify these parameters using the...