REQUIRED SOFTWARE Oracle Linux 5.10 iso file: V40139-01.iso [Enterprise-R5-U10-Server-x86_64-dvd.iso] Putty: putty.exe XMing: Xming-6-9-0-31-setup.exe INSTALLATION Oracle Enterprise Linux 5.10 Installation (VirtualBox) [PDF]
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…
DATABASE STATISTICS SCHEMA STATISTICS TABLE STATISTICS INDEX STATISTICS DICTIONARY STATISTICS FIXED OBJECT STATISTICS SYSTEM STATISTICS
Before starting, here is a PDF version of the document that I created years ago: Resolving In-Doubt Transactions Distributed transactions perform DML on multiple databases…