Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Static Data Dictionary Views, 221 of 452


DBA_RSRC_PLANS

DBA_RSRC_PLANS lists all resource plans in the database. For a list of currently active plans, see "V$RSRC_PLAN".

See Also:

 

Column  Datatype  NULL  Description 

PLAN 

VARCHAR2(30) 

 

Name of the resource plan 

NUM_PLAN_DIRECTIVES 

NUMBER 

 

Number of plan directives for the plan 

CPU_METHOD 

VARCHAR2(30) 

 

CPU resource allocation method for the plan 

MAX_ACTIVE_SESS_TARGET_MTH 

VARCHAR2(30) 

 

Reserved for future use. 

PARALLEL_DEGREE_LIMIT_MTH 

VARCHAR2(30) 

 

Parallel degree limit resource allocation method for the plan 

COMMENTS 

VARCHAR2(2000) 

 

Text comment on the plan 

STATUS 

VARCHAR2(30) 

 

Status of the plan: PENDING if it is part of the pending area, ACTIVE otherwise 

MANDATORY 

VARCHAR2(3) 

 

Whether the plan is mandatory 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index