tblspc_temp_files.sql
This script help you to find the information about temp tablespace files in oracle database.Call the script @tblspc_temp_files.sql Click here […]
Scripts
Scripts
Scripts
tblspc_temp_free.sql
This script help you to find the information about temp tablespace usage in oracle database.Call the script @tblspc_temp_free.sql Please share
Scripts
tblspc_files.sql
This script help you to find the information about tablespace usage in oracle database.Call the script @tblspc_files.sql Click here for
Scripts
tblspc_free.sql
This script help you to find the information about tablespace usage in oracle database. Call the script @tblspc_free.sql Please share
Scripts
Displays information about PGA usage for each session
This script help you to find the PGA usage in oracle database. Call the script @pga_usage.sql Lists all invalid objects
Scripts
Lists all invalid objects in the database
This script share the details of all invalid objects in oracle database. Displays temp usage for all session currently using
Scripts
Displays temp usage for all session currently using temp space
You can create this script and call it @temp_usage on sqlplus prompt to check the all session are currently using