1. Find the SQL_ID: If you are not going to use a SQL Tuning Set which is a set of pre-captured SQL Ids or manually…
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…