Tag: Oracle

Cursor: Pin S Wait on X in the Top 5 Wait Events

When a new cursor is given to Oracle to execute, it first needs to check if there is already such cursor in the Shared Pool, so we will not need to go to the expensive process of a hard parsing it again. To check this quickly, a hash value is generated from the text of the SQL .

Read More >

Log Buffer #280, A Carnival of the Vanities for DBAs

This Log Buffer Edition is sparkling with fresh and budding blogs. This Log Buffer #280 is is encompassing Oracle, SQL Server and MySQL blogs. Please give your feedback in the comments. Enjoy

Read More >

Log Buffer #279, A Carnival of the Vanities for DBAs

In a typical organization, all work together to bring out a common good for the outside world. It’s interesting to see how all of these entities blog about technology, and there is more and more interest shown by managerial technologists about databases. This Log Buffer Edition appeases their appetites. Enjoy!

Read More >

SNAPSHOT CONTROLFILE Isn’t Just a Backup Copy of a Control File Anymore

Recently I have troubleshooted failing RMAN backups in a 11.2.0.2 RAC environment. The backups failed with the error message “ORA-00245: control file backup operation failed”. The solution for the issue is simple. Here it is!

Read More >

Case Study: DBA Under Pressure for Performance Troubleshooting on Friday 13

On Friday 13 of June 2012, I was an on-call Oracle DBA. I got to work on a high priority client’s request. One of our client’s financial team was executing final steps of a year closing process in their ERP production environment and had a problem. The step that I received a complain about took 2 hours and still didn’t complete.

Read More >

Log Buffer #278, A Carnival of the Vanities for DBAs

Some parts of the world are going through winter in swing while others are savoring summer (or suffering through it!). This variation in weather is beautifully in-sync with the variety of blog posts sprouting all over the web, especially regarding database technology. This mixed flavor of database blogs is captured once again by this Log Buffer Edition.

Read More >

How to Prepare for Oracle Database 11g Certified Master Exam

Since a third person just asked me how to prepare for OCM exam in last 2 days, I decided to make my answer publicly available. I will leave you to discover the formal path yourself and give you a guideline in terms of the how-to and length of the preparation.

Read More >

How to Deal with Jobs Belonging to Other Users

This is not the first time I have run into this issue – in the past I (and who knows how many more Oracle DBAs) have had to deal with handling jobs from a different user, which usually ends in a big error. The answer to my prayers was the undocumented dbms_ijob package.

Read More >

Log Buffer #277, A Carnival of the Vanities for DBAs

Database bloggers are blowing their trumpets at full throttle, warming up the hearts of readers across the globe with cool tips, nifty tricks, and glimmering gems. This Log Buffer Edition picks those gems and offers them to you.

Read More >

DBD::Oracle 1.46 and 1.47_00 Hit CPAN

After a little more than two weeks of soaking without any issues (yay!), version 1.45_00 of DBD::Oracle has been promoted to general use as v1.46.

And because some contributors have been very busy in the meantime, the next trial version, v1.47_00, is also already on its way to CPAN. This new version offers a few bug fixes (more details in the changelog excerpt below) as well as a rework of the platform-specific troubleshooting guides as POD documents. As usual, it’ll be left around for a minimum of two weeks before it gets promoted to v1.48. Happy upgrade!

Read More >
Page 31 of 141« First Page...10...2930313233...40...Last Page »