Blog Aggregator - Amardeep Sidhu

I am not a DBA, but that doesn’t mean I lack respect for how difficult planned upgrades can be in complex Enterprise deployments. If I was a DBA planning an upgrade of my Oracle Database 10g Release 2 database I would be looking forward to 10.2.0.4. From what I’ve seen it looks like a pretty […]

I try not to make announcements about past posts, however, I noticed that my index page of 11g related posts was incomplete. Those of you who pick up my posts by RSS will have seen this stuff already. New readers that have been using the indexed pages might care to go to my index of […]

If you are using Linux and not rotating your alert logs, listener logs, any log actually, or rotating them with your own scripts, check out logrotate. I did not know this existed. From Dizwell.

This blog will be our groups opportunity to set the record straight on the Oracle Cost Based Optimizer, and the statistics that feed it. It will also give you the opportunity to post questions and have them answered by the team.

I’m pretty sure I’ve worked with Terry in the past.

Many times in fact, many many times.

Don’t be a Terry

Since Oracle Database 10g Release 10.2.0.4 looms, I should think there are a lot of folks thinking about planned upgrades. All told, I should think 10.2.0.4 would be a very desirable upgrade for Oracle Database 9i and earlier 10g deployments. Too bad it takes so long to get applications certified with new releases such as […]

Last week NetApp announced that it was the only company which is fully complient with Oracle’s HARD-Initiative for the prevention of data corrution on  NFS, FCP, and iSCSI protocols with its Snapvalidator software.
This software validates a checksum which Oracle created for a buffer before it started writing it to disk. If the checksum of the block which […]

A new note called “10g Upgrade Companion” has been published in Metalink recently. The note talks about the upgrade from 9i to 10g and lists recommended patches, behavior changes and best practices. While I was going through it I saw something I was not aware of before. In the “behavior changes” section it says: “Bind peeking has been extended to binds buried inside expressions.”.

I have talked

Last week I attended a training on AIX system administration from IBM (organized by company, obviously It was a 7 days course covering all of the system administration stuff. There was a lot of new stuff to learn, LVM being the most number of times uttered word, once we did the chapter on LVM. […]

Eddie Awad started a new series Oracle in 3 minutes on his blog. In the first post he has discussed about multi-versioning. Its a must watch for everyone who is working on Oracle. Hoping to get more of such stuff from Eddie.
Sidhu