Gunther Oracle APEX und Datenbank Wiki

Inhaltsverzeichnis

Den Oracle Resource Manager ab 11g verwenden
- Abfragen
- Quellen

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 resource_manager.sql

Quellen

Doku:

Netz: