Pages

▼
Monday, May 11, 2009

Collaborate 09 Ends

›
I wrapped up a hectic three days at Collaborate this year. As if to echo the sentiments on the economy in general, and Oracle database techn...
1 comment:
Friday, March 13, 2009

Excellent Information on Exadata

›
If you are interested to know more about the technology (not the marketing hype) behind Exadata - the datawarehouse appliance from Oracle, I...
2 comments:
Saturday, January 24, 2009

Ultra-Fast MV Alteration using Prebuilt Table Option

›
Here is an interesting question posed to me one time and I had found a solution. After 9 years, I encountered the same question and was shoc...
22 comments:
Tuesday, January 20, 2009

›
The other day, we had a serious issue in the ASM diskgroups - one diskgroup refused to come up because one disk was missing; but it was not ...
1 comment:
Monday, January 19, 2009

Making a Shell Variable Read Only

›
Being inherently lazy, I am always a sucker for shortcuts, neat tricks to cut my work and, most important, not to do the same thing again an...
8 comments:
Friday, October 10, 2008

About Clear Communications

›
Like everyone else I like to rant once in a while. I rant about the shortcomings in Oracle software, the tools and technologies I work with....
11 comments:
Sunday, October 05, 2008

Upgrade Experience for Patchkit 11.1.0.7

›
The first patchkit for 11g - 11.1.0.7 - came out a few weeks ago, for Linux systems. Unlike most other patchkits, this one contains some new...
16 comments:
Sunday, September 28, 2008

Most Striking Object at Open World 08

›
What was the most amazing thing I witnessed for the first time at OOW 08? Hands down, it is the compostible drinking cup ! Yes, compostible...
1 comment:

OOW'08 Oracle 11g New Features for DBAs

›
It was my second session at Open World this year. It was full with 332 attendees with a whopping 277 attendees on wait list! the room capaci...
8 comments:

OOW'08 : Real Life Best Practices for DBAs

›
Once more, it was a full session with 278 attendees and 251 waitlisted due to lack of space! I wish the organizers simply moved to a bigger ...
10 comments:

OOW'08 Partitioning - Why, When, What and How

›
I had a full session (300+ in attendance with 120 wait-listed). There was a gentleman from the organizing team who was trying to let in peop...
5 comments:

OOW'08 ACE Directors Forum Session

›
Lewis Cunningham kindly took the reins of organizing a unique session - a panel of ACE Directors. But instead of a panel didcussing some top...
3 comments:
Wednesday, September 24, 2008

From the Trenches at OOW'08

›
I had two sessions today: (1) I signed up a Unconference session - "Practical 11g Upgrade". I signed up for this on the spot; so I...
Wednesday, September 17, 2008

Speaking on Partitioning at NY Metro Oracle Day

›
I recently delivered a session at New York Metro Area Oracle Day organized by User Groups in New York, New Jersey and Connecticut. If you at...
Monday, September 01, 2008

Magic of Block Change Tracking

›
The other day, one of the instances of our main 3-node RAC database crashed due to an I/O error. Apparently there were many "dead paths...
22 comments:
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...
27 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 ...

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 ...
3 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...
17 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...
5 comments: