Manoj Appully
A return from hibernation with Exadata ...
Almost one year to date since my last blog. A year has gone but it seems like yesterday. Don't ask where I was and what I was doing, it...
top of page
The App Modernization Company
Search
Manoj Appully
Aug 31, 20142 min read
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...
84 views0 comments
Manoj Appully
Jul 31, 20142 min read
Beware of the Hibernate traps
Today most Java programmers use some type of JPA like Hibernate or TopLink to traverse the world of Objects and Relations Databases like...
54 views0 comments
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...
74 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
Feb 27, 20143 min read
Sun T-Series servers and Oracle database
In this article I am going to narrate a rather strange performance issue that I was pulled into. One of our client's called me to inform...
13 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...
78 views0 comments
Manoj Appully
Dec 31, 20132 min read
If you have a New Year resolution then add this one too !
Ok, as another year rolls over and you wonder what happened, why everything in 2013 seemed like a blur just like the years before then...
12 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...
287 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...
568 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
Manoj Appully
Jun 30, 20133 min read
The great Cloud divide
In last month's column I had given a brief overview of this whole business called Cloud Computing. In this column I will tell you why...
7 views0 comments
Manoj Appully
May 31, 20135 min read
Cloud Computing Explained Simply
I wanted to take a few minutes to pen some of my thoughts about the so called "Cloud" revolution that has been underway for a few years...
11 views0 comments
Manoj Appully
Apr 21, 20135 min read
How many DBAs do you need?
I think today in most organizations, the answer to the above question lies at the two extremes. Either you have organizations that are...
28 views0 comments
Manoj Appully
Mar 30, 20133 min read
How many databases can a DBA support?
Another grey area in an age where everything and anything is obsessively analyzed and measured, is the question regarding how one can...
74 views0 comments
Manoj Appully
Nov 15, 20123 min read
Why is your Red Hat Linux OS flipping file systems to "Read Only"?
Most people who have worked on other Unix flavors like Solaris, HP-UX, IBM AIX, etc not used to Linux may have never heard of an OS...
6 views0 comments
Manoj Appully
Nov 5, 20123 min read
The downside risk of striping far and wide on your storage
I am sure you have heard the familiar adage espoused by most database and storage vendors - Stripe And Mirror Everything (SAME). This...
20 views0 comments
bottom of page