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 for tblspc_temp_free.sql Please share this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.Please comment here for your any query … Read more

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 this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.Please comment here for your any query related to above post. … Read more

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 Tablespace usage in oracle database Please share this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.Please comment here for … Read more

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 this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.Please comment here for your any query related to above post. … Read more

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 in the database Please share this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.Please comment here for your any … Read more

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 temp space Please share this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.Please comment here for your any query … Read more

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 temp space. Please share this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.Please comment here for your any query … Read more