DBA Data[Home] [Help] [Dependency Information]


TABLE: SYS.RESOURCE_PLAN$

Object Details
Object Name: RESOURCE_PLAN$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
NAME VARCHAR2 (128)
MANDATORY NUMBER

CPU_METHOD VARCHAR2 (30)
MAST_METHOD VARCHAR2 (128)
PDL_METHOD VARCHAR2 (128)
NUM_PLAN_DIRECTIVES NUMBER

DESCRIPTION VARCHAR2 (2000)
STATUS VARCHAR2 (128)
QUE_METHOD VARCHAR2 (128)
SUB_PLAN NUMBER

MGMT_METHOD VARCHAR2 (128)
MAX_IOPS NUMBER

MAX_MBPS NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJ#
,      NAME
,      MANDATORY
,      CPU_METHOD
,      MAST_METHOD
,      PDL_METHOD
,      NUM_PLAN_DIRECTIVES
,      DESCRIPTION
,      STATUS
,      QUE_METHOD
,      SUB_PLAN
,      MGMT_METHOD
,      MAX_IOPS
,      MAX_MBPS
FROM SYS.RESOURCE_PLAN$;

Dependencies

[top of page]

SYS.RESOURCE_PLAN$ does not reference any database object

SYS.RESOURCE_PLAN$ is referenced by following:

SchemaSYS
ViewDBA_RSRC_PLANS
Package BodyDBMS_PRVTRMIE - show dependent code
PL/SQL PackageDBMS_PRVTRMIE - show dependent code
Package BodyDBMS_RMGR_PLAN_EXPORT - show dependent code
Package BodyDBMS_RMIN_SYS - show dependent code
Package BodyDBMS_WLM - show dependent code
ViewKU$_RMGR_PLAN_VIEW