There is a bug with oracle 9i and materialized views whereby there are numerous snapshot too old errors. This bug is around the source database whereby the optimizer is giving an incorrect execution plan, when the parameter star_transformation_enabled is set to TRUE.
This bug is fixed in oracle 10.0. The workaround is to change the parameter to temp_disable.
skip to main |
skip to sidebar
Labels
- architecture (2)
- bug (1)
- certification (1)
- character set (2)
- constaints (1)
- database links (2)
- dba (2)
- ddl (1)
- discoverer (1)
- Discussion (3)
- dml (1)
- dynamic sql (1)
- exceptions (1)
- execute immediate (1)
- faq (1)
- flashback (2)
- hardware (2)
- hints (3)
- keyboard (2)
- locks (1)
- mac (2)
- materialized views (1)
- partitions (3)
- performace (3)
- performance (1)
- plsql (4)
- recovery (2)
- redo (1)
- sizing (1)
- SQL (8)
- star (1)
- storage (1)
- table (1)
- tables (1)
- tablespaces (2)
- temp tablespace (1)
- transformation (1)
- tuning (1)
- UNDO (4)
- unix (1)
- upgrade (1)
- waits (1)
- wrapper (1)
- xplan (2)
me
