Greg over at Structured Data has a fantastic piece titled "Troubleshooting Bad Execution Plans" which is a must-read for all. Learning about the GATHER_PLAN_STATISTICS hint alone was worth the price of admission.Also time for me to re-evaluate the changes I made to OPTIMIZER_INDEX_CACHING and OPTIMIZER_INDEX_COST_ADJ a few versions back:SQL> show... [Read More]
Scalar::Util on CentOS5 is Bustinated
While trying to install pastebot on my CentOS5 sandbox for interal IRC usage, I found that I had to install a number of other perl modules upon which pastebot depended. This however became very frustrating as nearly all of them failed.I ended up following the dependency chain to eventually find out that IO::Compress::Base... [Read More]
Tuning Backup & Recovery
A level 0 database backup of my production instance takes over 8 hours, and duplication is just as long, if not longer. I’m going to do some reading and see if we can shore things up. I’ll report back. The database is around 1.1 terabytes. Some have told me that their databases... [Read More]
OTN downloads may not be supported!
This is certainly good to know. Of course my current production and development databases were OTN downloads, patched to 10.2.0.2 from the Metalink patchset.
Doug Burns wrote a great piece about how few people apply the latest patchsets and how almost no one applies the CPUs.While my databases are all 10.2.0.2, I've only just begun looking at applying CPUs starting with the October CPU (they are cumulative).We were also looking at finally upgrading to... [Read More]