Category: Oracle performance tuning

How to Tune Full Table Scan?

How to Tune Full Table Scan?

June 5, 2014 | By | Add a Comment

Eliminating DB File Scattered Reads of Oracle Wait Event In Oracle, a DB file scattered read normally indicates a full table scan. A DB file scattered read is the same type of wait event as DB file sequential read, except that Oracle is reading multiple data blocks. Depending on the setting for the DB_FILE_MULTIBLOCK_READ_COUNT parameter […]

Read More

Oracle Tuning using System Load Performance

Oracle Tuning using System Load Performance

January 30, 2012 | By | 1 Comment

System Load is the key feature to observe Oracle Database Performance: System load levels are determined by all of the processes sharing the kernel run queue. If there are not enough CPU cycles to handle the workload of all such processes efficiently, chance are that the processes have to get in line, waiting for the […]

Read More

Disk IO tuning of Oracle OLTP

Disk IO tuning of Oracle OLTP

August 26, 2011 | By | Add a Comment

Disk IO tuning using read ahead caches and system caches

Read More

What is RAID

What is RAID

August 7, 2011 | By | Add a Comment

RAID usage for improving disk I/O and deployment of parallel processing

Read More

Oracle Disk I/O Tuning-1

Oracle Disk I/O Tuning-1

February 23, 2011 | By | Add a Comment

Oracle disk IO performance Tuning using raw devices

Read More

Oracle Performance Tuning Skills

Oracle Performance Tuning Skills

February 21, 2011 | By | Add a Comment

Achieve Goal of Oracle Performance Tuning of Oracle database server

Read More