Category: Oracle performance tuning
Prevent fragmentation in a tablespace is most crucial part of database administration. It degrades performance and wastes disk space. The article explains how fragmentation occurs in dictionary managed tablespace in Oracle database. Tablespace fragmentation is fairly common in most databases, and to a certain degree, it is almost inevitable, unless specific steps are taken to […]
Read More
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
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 using read ahead caches and system caches
Read More
RAID usage for improving disk I/O and deployment of parallel processing
Read More
Oracle disk IO performance Tuning using raw devices
Read More