=====Den Oracle Resource Manager ab 11g verwenden=====
=== Session Handling ===
Eine Session höher prioriseren:
BEGIN
DBMS_RESOURCE_MANAGER.SWITCH_CONSUMER_GROUP_FOR_SESS (
session_id => '213'
, session_serial => '2132131'
, consumer_group => 'HIGH_PRIO' );
END;
==== Abfragen ====
Script:
SET linesize 130 pagesize 100 recsep OFF
prompt .... Viewing Consumer Groups Granted to Users or Roles
select grantee
, granted_group
, grant_option
, initial_group
from dba_rsrc_consumer_group_privs
order by grantee
/
prompt .. Viewing Plan Schema Information
column plan format a27 heading "Plan"
column status format a10 heading "Status"
column comments format a100 heading "Comment" WORD_WRAPPED
column cpu_method format a10 heading "CPU_METHOD"
column mgmt_method format a10 heading "CPU_METHOD"
column parallel format a20 fold_after
select plan
, status
, cpu_method
, mgmt_method
, parallel_degree_limit_mth as parallel
, comments
from dba_rsrc_plans
order by status
/
prompt .. show user waiting with resource limit
select sid
, serial#
, username
, resource_consumer_group
from v$session
where event like 'resmgr%'
/
Aktuellste Version siehe auch [[http://orapowershell.codeplex.com/SourceControl/latest#sql/resource_manager.sql|resource_manager.sql]]
==== Quellen ====
Doku:
* http://docs.oracle.com/cd/B28359_01/server.111/b28310/dbrm004.htm#ADMIN11886
* http://docs.oracle.com/cd/E11882_01/server.112/e17120/dbrm.htm#ADMIN027
* http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_resmgr.htm#CFAGGDBD
Netz:
* http://www.oracle.com/technetwork/database/performance/resource-manager-twp-133705.pdf
* http://oracle-base.com/articles/10g/resource-manager-enhancements-10g.php
* http://www.oracle.com/webfolder/technetwork/de/community/dbadmin/tipps/resource_manager/index.html
* http://jhdba.wordpress.com/2011/10/19/resource-manager-plans-during-the-automatic-maintenance-window/