Oracle Upgrade Failures due to METHOD_OPT and XDBCONFIG

Background I recently experienced a problem when upgrading an old Oracle database to that had no matches in a My Oracle Support (MOS) or Google search. The problem presented itself initially when upgrading as the following error was…

Read More >

Statistics gathering and SQL Tuning Advisor

Our monitoring software found a long running job on one of our client’s databases. The job was an Oracle’s auto task running statistics gathering for more than 3 hours. I was curious to know why it took so long and…

Read More >