What is slewing?The NTP daemon will periodically update the system clock with the time from a reference clock. If the time on the reference clock…
REQUIRED SOFTWARE Hypervisor: VirtualBox-5.1.18-114002-Win Linux Image: rhel-server-7.2-x86_64-dvd.iso Putty: Putty v0.63 XMing: Xming 6.9.0.31 INSTALLATION Red Hat Enterprise Linux 7.2 Installation (VirtualBox) [PDF]
REQUIRED SOFTWARE Hypervisor: Oracle VirtualBox 5.2.6 Linux Image: rhel-server-6.9-x86_64-dvd.iso Putty: Putty v0.63 XMing: Xming 6.9.0.31 INSTALLATION Red Hat Enterprise Linux 6.9 Installation (VirtualBox) [PDF]
REQUIRED SOFTWARE Hypervisor: Oracle VirtualBox 5.2.6 Linux Image: OracleLinux-R6-U9-Server-x86_64-dvd.iso Putty: Putty v0.63 XMing: Xming 6.9.0.31 INSTALLATION Oracle Enterprise Linux 6.9 Installation (VirtualBox) [PDF]
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…
1. Create a seperate tablespace for the STATSPACK user: It is a recommended best practice to create a seperate tablespace for the STATSPACK user. The…