Oracle Database - Data Warehousing

Card Puncher Data Processing

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.





Discover More
Card Puncher Data Processing
Oracle Database - PGA_AGGREGATE_TARGET Parameter

PGA_AGGREGATE_TARGET is a database initialization parameter and controls the total amount of execution memory that can be allocated by Oracle for the Process global area (PGA) The Total Memory here refers...
Card Puncher Data Processing
Oracle Database - Parallel execution with Oracle Partitioning (parallel partition-wise join)

There are specific optimizations between SQL parallel execution and Oracle Partitioning that you should bear in mind when you plan to use these functionalities together. For example, two large partitioned...
Simple Ressource Plan
Oracle Database - Ressource Manager

With the Resource Manager, you can distribute available processing resources by allocating percentages of CPU time to different users and applications. [Simple Ressource Plan] In a data...
Oracle Database Direct Path Read Temp With Parallel Slave
Oracle Database - direct path read temp and direct path read wait event

“direct path read temp” and “direct path read” event are wait events. When a session is reading buffers from disk directly into the PGA (opposed to the buffer cache in SGA), it waits on this event....



Share this page:
Follow us:
Task Runner