There is a purge script named “sppurge” under the path “$ORACLE_HOME/rdbms/admin” to be executed manually from time to time to prevent the tablespace from filling up. See the below…
1. Create a seperate tablespace for the STATSPACK user: It is a recommended best practice to create a seperate tablespace for the STATSPACK user. The…