Oracle Database - Data Warehousing

> Database > Oracle Database

Table of Contents

1 - Subject

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.