Thursday, January 16, 2014

Using Oracle Orion for IO Calibration

ORION is a tool provided by Oracle to calibrate the IO of storage you are planning to use for database server. Some salient features of this tool are as follows

·         Oracle provided tool which can be downloaded separately

Tuesday, April 16, 2013

Oracle Stats Gathering During Automated Maintenance Tasks Window

Problem Background
A few days back I faced a problem when I received slowness complaints from end users who use an application based on our 11.1.0.7 database. While investigating, I came to know that at 10:00 AM, a stats gathering job started which lasted for 45 minutes and during this window,

Tuesday, August 23, 2011

Manual Database Creation for RAC

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

Log File Sync wait event and COMMIT

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 pushed to the server. 

Popular Posts - All Times