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
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
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.