‘An eye for eye
only ends up making the whole world blind.’ Gandhi |
Database Resource Manager
in the Oracle 10g database
Introduction
Oracle Database 10g
introduces new features to the Resource Manager for managing your
resources. For example: if you want that 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;
/
“In the end, we
will remember not the words of our enemies, but the silence of
our friends.” Martin Luther King Jr. |
Questions:
Questions on
Database
Resource Manager in the Oracle 10g database
Q: How to do you use the
DBMS_RESOURCE_MANAGER package to tell the PMON process to kill
sessions that are idle for longer than 600 seconds and kill sessions
that are idle for more than 300 seconds and are blocking other
sessions. We assumed that you have already defined your plan as ‘MY_DAY_PLAN’
and your group as ‘MY_FIRST_GROUP.’
|
|