top of page

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...

Row Chaining And Row Migration

Remove Table Fragmentation in Oracle

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

Remove Table Fragmentation in Oracle

Golden Gate Performance Tuning

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

Golden Gate Performance Tuning

Oracle Table and Index Partitions

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

Oracle Table and Index Partitions

Oracle TKPROF Utility

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

Oracle TKPROF Utility

Oracle ADDM Report

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

Oracle ADDM Report

Find SQL Id of the Statement You Just Ran

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...

Find SQL Id of the Statement You Just Ran

Find Session Id Running Specific Query

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

Find Session Id Running Specific Query

Find SQL execution plan change

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...

Find SQL execution plan change

Wait events vs wait classes

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

Wait events vs wait classes

Find Blocked Sessions in Oracle

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

Find Blocked Sessions in Oracle

How to Increase MEMORY_TARGET

Before you can increase memory in oracle database, you must first understand four oracle memory parameters which govern the instance....

How to Increase MEMORY_TARGET
bottom of page