Pages

▼
Saturday, August 23, 2008

Diagnosing Library Cache Latch Contention: A Real Case Study

›
The other day, our data warehouse database was effectively down. The database was up and running; but all connection attempts to the databas...
28 comments:
Tuesday, August 19, 2008

Put External Procedures on a Different Listener

›
As a best practice, I recommend placing external procedures, if you use them, on a different listener.ora file. Why so? External Procedures ...
1 comment:

Why should you set the ADMIN_RESTRICTIONS_LISTENER to ON

›
Recently someone probably went through the slides of my session on "Real Life DBA Best Practices" and had a question on OTN forum ...
4 comments:
Saturday, August 09, 2008

Resource Manager I/O Calibration in 11g

›
You are considering a new platform for the Oracle database; or perhaps worried about the I/O capabilities of the existing platform. How do y...
18 comments:
Thursday, August 07, 2008

Full Table Scans on RAC

›
The phone goes off, yet again, and this time it seems to be a serious problem. Here are the symptoms: all the applications seems to be worki...
6 comments:
Monday, August 04, 2008

Issues in RAC with Wrong Listener Configuration

›
The one thing that frustrates me the most is the lack of clear communication. Without clarity in what is being transpired, it's impossib...
4 comments:
Wednesday, July 30, 2008

My Little World in Open World

›
Oracle Open World is coming up in just two months ... actually sooner. It will be quite active for me. First, I am sharing the stage with a ...
4 comments:
Wednesday, January 16, 2008

Comparing CLOBs

›
What if you have two CLOB columns to compare? A construct like select someColumn from tab1 where col1 != col2 will not work. This is how yo...
2 comments:
Tuesday, July 31, 2007

Auditing Nuances

›
I had posted it earlier on my other blog - Oracle Security Musings ( http://www.proligence.com/blog/index.html ). I reproduce here. This cam...
7 comments:

A recent picture

›
someone observed that my picture on OTN appears much younger than what I really look. Well, the OTN picture was taken some 4 years ago. Here...
5 comments:

RAT in 11g Replacing QA Team?

›
We are in the process of moving to a different hardware and cluster technology and the quesiton on everyone's mind is: will it perform. ...
4 comments:

Standby Database Using RMAN

›
I learn something about Oracle everyday and in the last few days the learnings have been rather painful. I have been trying to create a phys...
17 comments:

Resuscitating the Comatose

›
Well, my foray into world of bloging didn't have a great fanfare but I didn't expect it to die down so soon. Here is my attempt at B...
6 comments:
Monday, May 30, 2005

›
" What is a DBA ?" It has been a while since I last posted a blog. Lethargy is mostly the reason behind it; but lack of what to s...
9 comments:
Saturday, January 11, 2003

›
So, here I am, with my very own blog. I hope to post here my thoughts, sentiments, fights and agreements on a varietyof Oracle DBA related w...
8 comments: