Script to get Tablespace report in html format. Run the below script on SQL prompt of oracle database . It generates tbs_rep.html file . SET MARKUP HTML ON ENTMAP OFF
PT Issue: step by step Doc to generate good plan from nonPROD to PROD. Issue in detail: Query Performance of Hyperion application monthly batch job in PROD is very slow
Troubleshooting queries on Oracle Database If there is any performance issue in the environment/application , need to do some troubleshooting steps on Database as given below to verify if there
script to verify oracle tablespace usage set pages 200 lines 150 col TOTAL_MB format 9999999.00 col USED_MB format 9999999.00 col FREE_MB format 9999999.00 col PCT_USED format 999.9 col PCT_FREE format
Error – Not able to connect with EZconnect format using sqlplus. Error : ORA-12537 | ORA-12545 ORA-12537: TNS: connection closed ORA-12545: Connect failed because target host or object does not
Query to display/report FULL and INCR backup details of database. In this article, we will demonstrate about the queries that provide FULL and INCR backup details of a oracle database.
