| Pro-active
management of DW Workloads |
|
|
|
|
|
|
|
|
|
|
|
|
| • | Predictive
Query Governing and Dynamic Re- |
||||||||||
| prioritization: |
|||||||||||
| – | Queries which
are estimated to take longer than an |
||||||||||
| DBA-specified
limit will abort or be ‘de-prioritized’ |
|||||||||||
| • | Automatic
Queuing: |
||||||||||
| – | A limit can be
set on the number of active session |
||||||||||
| for each group
of users; queries submitted which |
|||||||||||
| exceed this
limit will be queued |
|||||||||||
| • | Via Database
Resource Manager |
||||||||||