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

VIEW: SYS.DBA_RSRC_INSTANCE_CAPABILITY

Object Details
Object Name: DBA_RSRC_INSTANCE_CAPABILITY
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

per-instance settings for database resources that are capable of being
managed by the Resource Manager

[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTANCE_NUMBER NUMBER

instance number
IO_SHARES NUMBER

number of I/O shares for this instance
STATUS VARCHAR2 (128)
PENDING if it is part of the pending area, NULL otherwise
Query Text

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


SELECT INSTANCE_NUMBER
,      IO_SHARES
,      STATUS
FROM SYS.DBA_RSRC_INSTANCE_CAPABILITY;

Dependencies

[top of page]

SYS.DBA_RSRC_INSTANCE_CAPABILITY references the following:

SchemaSYS
TableRESOURCE_INSTANCE_CAPABILITY$
SYS.DBA_RSRC_INSTANCE_CAPABILITY is referenced by following:

SchemaPUBLIC
SynonymDBA_RSRC_INSTANCE_CAPABILITY