Rsrc plan status summary

Fiche express
Type	Script SQL*Plus de diagnostic (Database Resource Manager)
Voir aussi	Rsrc plan status detail

Rsrc plan status summary donne une vue résumée des plans de ressources du Database Resource Manager : nom, commentaire de description, nombre de directives et état d'activation — sans le détail des méthodes d'allocation (CPU, pool de sessions, etc.) que fournit Rsrc plan status detail.

Script

SET TERMOUT OFF
COLUMN current_instance NEW_VALUE current_instance NOPRINT
SELECT rpad(instance_name, 17) current_instance FROM v$instance;
SET TERMOUT ON

PROMPT
PROMPT +------------------------------------------------------------------------+
PROMPT | Report   : Database Resource Manager - Resource Plan Summary Report    |
PROMPT | Instance : &current_instance                                           |
PROMPT +------------------------------------------------------------------------+

SET LINESIZE 180
SET PAGESIZE 50000
CLEAR COLUMNS
CLEAR BREAKS
CLEAR COMPUTES

COLUMN resource_plan_name  FORMAT a30 HEAD 'Resource Plan Name'   JUST left
COLUMN comments            FORMAT a50 HEAD 'Comments'             JUST left WRAP
COLUMN num_plan_directives FORMAT 999 HEAD '# of Plan|Directives' JUST left
COLUMN status              FORMAT a10 HEAD 'Status'               JUST left
COLUMN mandatory           FORMAT a10 HEAD 'Mandatory?'           JUST left
COLUMN run_status          FORMAT a11 HEAD 'Run|Status'           JUST left

SELECT
    a.plan                 resource_plan_name
  , a.comments              comments
  , a.num_plan_directives   num_plan_directives
  , a.status                status
  , a.mandatory             mandatory
  , DECODE(b.name, a.plan, 'Running', 'Not Running') run_status
FROM
    dba_rsrc_plans a LEFT OUTER JOIN v$rsrc_plan b ON (a.plan = b.name)
/

Voir aussi

• Rsrc plan status detail — même rapport, avec le détail des méthodes d'allocation