Performance Tuning

Row Chaining And Row Migration

Two of the most important concepts when it comes to Performance Tuning. As a DBA, your job is reduce Row Chaining and Row Migration as...

Fragmentation causes database slowness and un-necessary storage space wastage. In this article I will show you how to find if a table is...

Golden Gate Performance Tuning is the process of optimizing the performance of Oracle Golden Gate replication. It can be done by...

Partitioning allows tables and indexes to be divided into small parts for easy management inside database. You can create small portions...

Tracing an SQL statement is the first step towards fixing a slow running SQL. Oracle allows you to enable SQL Tracing for a particular...

It analysis AWR report to identify potential performance bottle neck. For each identified issue, it locates the root cause and provides...

It analysis AWR report to identify potential performance bottle neck. For each identified issue, it locates the root cause and provides...

While connected to the database, you might want to know the sql id of the query you just ran (in your own session, not some other...

At times DBAs need to find or search for session details that are running a specific query inside database. Example, you might want to...

If you would like to find out change in SQL plan of a query, below script will help you find the SQL plan ID for previous executions and...

Did you know that all the wait events inside Oracle database are categorized into wait classes? Every wait event always belongs to a wait...

Oracle locking mechanism keeps database objects isolated from accidental changes by multiple users at a given point of time. Locks are...