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…