Manoj Appully
RAC and Index Contentions
If your application happens to be one where surrogate keys are used in abundance and if some of those tables are inserted/updated very...
top of page
The App Modernization Company
Search
Manoj Appully
Jun 2, 20142 min read
Foreign Keys with no indexes equals enq: TM Contention
One of the simplest and often overlooked act when designing a data model in Oracle is omitting indexes on foreign keys. While I am not a...
75 views0 comments
Manoj Appully
Apr 30, 20142 min read
Beware of uncommitted updates during heavy selects in Oracle RAC
One of the often overlooked aspect of Oracle RAC is the impact of large changes on heavily accessed tables on overall RAC responsiveness....
25 views0 comments
Manoj Appully
Mar 31, 20142 min read
How to use ASH report to pinpoint issues in Oracle?
Oracle has another nifty report that helps you dive into more granularity on the happenings within a DB that AWR reports cannot. ASH...
60 views0 comments
Manoj Appully
Jan 31, 20144 min read
A Layman's guide to interpreting Oracle AWR Reports Take Two - I/O Waits
In my previous blog about interpreting AWR reports in Oracle, I had only skimmed the surface, enough to give any one a quick idea of what...
81 views0 comments
Manoj Appully
Nov 30, 20132 min read
A simple tool to measure DB performance
This post is primarily for the Oracle DBAs out there who would like a quick look at the load on a database, be it single instance or RAC....
20 views0 comments
Manoj Appully
Oct 31, 20132 min read
Basic differences between a SQL Profile & SQL Baseline in Oracle
In the previous articles I have explained simple methods on how to interpret an AWR report, how to find an expensive SQL and how to tune...
299 views0 comments
Manoj Appully
Sep 30, 20133 min read
A Layman's guide to fixing Bad SQL performance
The last two blogs that I had about a “Layman’s guide to AWR” and “How to find expensive SQL”? should help one identify or smell out...
21 views0 comments
Manoj Appully
Aug 24, 20138 min read
A Layman's guide to quickly interpreting Oracle AWR reports
If you have worked in IT long enough then it is hard to miss the acronym "AWR". AWR is short for Automatic Workload Repository report and...
578 views0 comments
Manoj Appully
Jul 23, 20136 min read
A Layman's guide to identifying expensive SQL in Oracle
Most often than naught you may find yourself wondering what is causing all the latency in the application. You quickly decide without any...
40 views0 comments
bottom of page