Tuesday, August 23, 2011

Manual RAC Database Creation

This document provides step by step instructions to create a RAC database manually. This procedure was tested on 11g, but should also work for other Oracle versions without or with some slight modifications. Following are the assumptions

Monday, March 28, 2011

Installing Oracle Database 11.2 on IBM AIX 6.1 (Includes HACMP)

SWAP space recommendation from Oracle corp. for Oracle 11g Release 2


If RAM is between 1 GB and 2 GB, SAWP should be 1.5 times the size of RAM
If RAM is between 2 GB and 16 GB, SWAP should be equal to the size of RAM

Monday, March 7, 2011

Don't COMMIT Too Often

Log Writer or LGWR is Oracle instance’s background process which has the responsibility to read from the redo log buffer cache and write into the redo log files. LGWR writes to the redo log file
1) Every 3 seconds
2) When the redo log buffer is one-third full

Sunday, February 20, 2011

CPU Percentage Vs. CPU Load Average for DBAs

Most of the people, specially, working on Windows platform don’t know much about Load Average of CPU and just take a look at the CPU usage %age. On Linux based platforms load average or run queue length is a very important indicator to check how much is the load on the CPUs of the system and whether current number of CPUs enough to support the workload

Popular Posts - All Times