Tuning a Very Large Data Warehouse . Pichai Bala. About Me. Working in the IT industry for the past 17 years Working in Oracle since 1993. Working in Data Warehouse and BI since 2003. Disclaimer. The views expressed in this presentation are
The views expressed in this presentation are
mine and does not represent the organization I work for
or the organizations I had worked for in the past.
Please always test and validate the ideas presented here
in a test environment first.
…and gets into the Death Spiral
Caveat: Joins beware.
ORA-01735: invalid ALTER TABLE option
For MV Fast Refresh to be successful a Complete Refresh should happen before
Partition exchange has issue with BITMAP indexes with the ora error for mismatch indexes 0RA-14098
Fix the code and fix the problem.