RAC Administrator Certified Expert certification.

This saturday I have written certification exam 1Z0-048 and scored 100% marks

 

Surprised impact of Improved Performance

It’s always desirable to have database running in optimal performance state. I, as a DBA, even have same desires. But sometimes improved performance may negatively impact on the system users and left you in a situation where you don’t know how to react.

I personally have such an experience. Two years back, I worked for a customer from telecom domain. One of their call center’s application had performance problem. They log a Service request for optimization. Basically, call center guys generate a report on daily basis for number of complaint received. This is for management for MIS purpose. They observed that now it take more than 1 hour to generate the report.

I as a performance DBA, trace the session for report generation and observed that only one query out of several is bottleneck. Query is based on a table whose size is more than 15 GB. Since they were retriving only 1-day of data, I range-partitioned the table on complaint_date column. After partitioning, report completed in 7-10 minutes.

User’s first reaction was, after implementation, report generation was having some problems. When I asked what was the problem, he said, it was not generating complete report. His logic was, it just finished in 10 minutes, so it was not running completely.

I smiled and said “what they guys were expecting from this exercise, performance improvement or something else?”

Oracle RAC Certification 1Z0-048

I started preparing for the exam on 1st April and planning to write it on 25 or 26th April.

While preparing for the exam, I strongly feel the need for Practical exam (as in OCM) instead of objective-questions based. Since it’s an expert-level OCP exam, there must be a 1-day practical lab-based exam which should check practical knowledge like RAC installation, solving performance problem, configuration …

There may me my drawback also. It’s fees may go sky-rocketed as the case with OCM exams.

What do you think?