Proposed Solutions
- Change Oracle's statistics gathering function to run between 04:00 - 05:00 instead at 22:00
- Oracle assumes to be the only active user during stats gathering
- All the tables, indexes, views need to be created in the same order via scripts
- Switch to RBO (Rule Based Optimizer) for certain views
- Eventual deterministic/stable performance after queries have been tuned
Activity Log
Wednesday 10-10-2007
- 06:07 (Prabhu) Recreated 5 CM tables
...