|
Database
Resource Manager in the Oracle 10g database
|
More Resources by
Google: |
|
|
|
|
|
‘An eye for
eye only ends up making the whole world blind.’
Gandhi
|
Database
Resource Manager in the Oracle 10g database
Oracle
Database 10g introduces new features to the Resource Manager for managing your
resources. For example: if you want
the PMON process kills sessions that are idle for longer than 600 seconds and
kills sessions that are idle for more than 300 seconds and are blocking other
sessions, then you should use the DBMS_RESOURCE_MANAGER package. We assumed that
you have already defined your plan as ‘MY_DAY_PLAN’ and your group as ‘MY_FIRST_GROUP.’
SQL>
BEGIN
DBMS_RESOURCE_MANAGER.create_plan_directive
(
PLAN
=>
‘MY_DAY_PLAN’,
GROUP_OR_SUBPLAN
=>
‘MY_FIRST_GROUP’,
COMMET
=> ‘Limit
user idle time’,
MAX_IDLE_TIME
=> 600,
MAX_IDLE_BLOCKER_TIME
=>
300);
END;
/
|