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 parameters optimizer_index
NAME TYPE VALUE
------------------------------------ ----------- -----
optimizer_index_caching integer 90
optimizer_index_cost_adj integer 10
21 November 2007
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 was failing because the Scalar::Util module, installed stock by CentOS, lacked the “XS” extension. A Google search led me to this bug report confirming it. Fortunately the problem is easily solved by doing a “force install Scalar::Util” in cpan.
Posted by Don Seiler at 12:03
13 November 2007
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 of similar size are backed up in only a couple of hours.
My main concern is the duplication, or restore & recovery. An 8 hour restore/recovery basically means the loss of a full business day (depending on when it is needed).
Posted by Don Seiler at 16:52