Oracle Database - Data Warehousing


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.

Powered by ComboStrap