Category: Oracle performance tuning

Oracle Performance Tuning -Application Optimizing is more important

Oracle Performance Tuning -Application Optimizing is more important

January 24, 2019 | By | Add a Comment

Application Optimizing is more important in Oracle Performance Tuning Applications often are an end user’s only access to the database. Only through an application can the end user peek into the database. In other words, the application offers database visibility to the end user. If the applications are up and running, the database is available. […]

Read More

Improve Oracle Database Performance using Data File Striping

Improve Oracle Database Performance using Data File Striping

January 10, 2019 | By | Add a Comment

While disk level striping really advantages many Oracle databases, Oracle databases necessitate striping at an additional granular level. Except we can streak in sizes of less than the cylinder size for the hard disk, the disk will have the hunt for disputation as the read-write head shifts among the cylinders.  In a perfect world, we […]

Read More

Fragmentation in Dictionary Managed Tablespace in Oracle Database

Fragmentation in Dictionary Managed Tablespace in Oracle Database

February 13, 2018 | By | Add a Comment

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

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