top of page
DBAGenesis_png.png

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

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

bottom of page