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...
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...
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...
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 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 ADDM Report
It analysis AWR report to identify potential performance bottle neck. For each identified issue, it locates the root cause and provides...
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 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 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...
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...
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...