Books for you

With the DRM, you can
dynamically alter the details of the plan without shutting down the instance.
Oracle9i added a number of significant improvements to the Database Resource
Manager. The DRM now allows a DBA to specify the number of active sessions available
to a consumer group. Any additional connection requests for the consumer
group are queued. By limiting the number of active connections, you can start to
avoid the situation where a request comes in that pushes the resource requirements
for a group over the limit and affects all the other users in that group.
Oracle9i also added to the Database Resource Manager the ability to proactively estimate
the amount of CPU that an operation will require. If an operation looks as if it
will exceed the maximum CPU time specified for a resource group, the operation will
not be executed, which can prevent inappropriately large operations from even
starting.
Finally, since Oracle9i, the DRM can also automatically switch a consumer group to
another consumer group if that group is active for too long.


Pages:
452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476