Oracle Database - Data Warehousing
Subject
- Result Set Cache,
The biggest wait event for large data warehouse sites is: a “direct path read” wait event
A shared server is not recommended in a datawarehouse environment because for instance a session can be prevented from migrating to another shared server when Parallel Execution is active.