sys@WORKFLOW>@mydesc.sql
Enter value for table_name: DBA_RSRC_CATEGORIES
Enter value for owner: SYS

NAME	TYPE	COMMENTS
NAME	VARCHAR2	Consumer group category name
COMMENTS	VARCHAR2	Text comment on the consumer group category
STATUS	VARCHAR2	PENDING if it is part of the pending area, NULL otherwise
MANDATORY	VARCHAR2	Whether the consumer group category is mandatory

sys@WORKFLOW>@mydesc.sql
Enter value for table_name: DBA_RSRC_CONSUMER_GROUP_PRIVS
Enter value for owner: SYS

NAME	TYPE	COMMENTS
GRANTEE	VARCHAR2	Grantee name
GRANTED_GROUP	VARCHAR2	consumer group granted to the grantee
GRANT_OPTION	VARCHAR2	whether the grantee can grant the privilege to others
INITIAL_GROUP	VARCHAR2

sys@WORKFLOW>@mydesc.sql
Enter value for table_name: DBA_RSRC_CONSUMER_GROUPS
Enter value for owner: SYS

NAME	TYPE	COMMENTS
CONSUMER_GROUP_ID	NUMBER	consumer group id
CONSUMER_GROUP	VARCHAR2	consumer group name
CPU_METHOD	VARCHAR2	deprecated - use MGMT_METHOD
MGMT_METHOD	VARCHAR2	resource allocation method for the consumer group
INTERNAL_USE	VARCHAR2	Whether the consumer group is for internal use-only
COMMENTS	VARCHAR2	Text comment on the consumer group
CATEGORY	VARCHAR2	Category of the consumer group
STATUS	VARCHAR2	PENDING if it is part of the pending area, NULL otherwise
MANDATORY	VARCHAR2	Whether the consumer group is mandatory

sys@WORKFLOW>@mydesc.sql
Enter value for table_name: DBA_RSRC_GROUP_MAPPINGS
Enter value for owner: SYS

NAME	TYPE	COMMENTS
ATTRIBUTE	VARCHAR2	which session attribute to match
VALUE	VARCHAR2	attribute value
CONSUMER_GROUP	VARCHAR2	target consumer group name
STATUS	VARCHAR2	PENDING if it is part of the pending area, NULL otherwise

sys@WORKFLOW>@mydesc.sql
Enter value for table_name: DBA_RSRC_IO_CALIBRATE
Enter value for owner: SYS

NAME	TYPE	COMMENTS
START_TIME	TIMESTAMP(6)	start time of the most recent I/O calibration
END_TIME	TIMESTAMP(6)	end time of the most recent I/O calibration
MAX_IOPS	NUMBER	maximum number of data-block read requests that can be susta
MAX_MBPS	NUMBER	maximum megabytes per second of maximum-sized read requests
MAX_PMBPS	NUMBER	maximum megabytes per second of large I/O requestslarge I/O
LATENCY	NUMBER	latency for data-block read requests
NUM_PHYSICAL_DISKS	NUMBER	number of physical disks in the storage subsystem (as specif

sys@WORKFLOW>@mydesc.sql
Enter value for table_name: DBA_RSRC_MANAGER_SYSTEM_PRIVS
Enter value for owner: SYS

NAME	TYPE	COMMENTS
GRANTEE	VARCHAR2	Grantee name
PRIVILEGE	VARCHAR2	name of the system privilege
ADMIN_OPTION	VARCHAR2	whether the grantee can grant the privilege to others

sys@WORKFLOW>@mydesc.sql
Enter value for table_name: DBA_RSRC_MAPPING_PRIORITY
Enter value for owner: SYS

NAME	TYPE	COMMENTS
ATTRIBUTE	VARCHAR2	session attribute
PRIORITY	NUMBER	priority (1 = highest)
STATUS	VARCHAR2	PENDING if it is part of the pending area, NULL otherwise

sys@WORKFLOW>@mydesc.sql
Enter value for table_name: DBA_RSRC_PLAN_DIRECTIVES
Enter value for owner: SYS

NAME	TYPE	COMMENTS
PLAN	VARCHAR2	Name of the plan to which this directive belongs
GROUP_OR_SUBPLAN	VARCHAR2	Name of the consumer group/sub-plan referred to
TYPE	VARCHAR2	Whether GROUP_OR_SUBPLAN refers to a consumer group or a pla
CPU_P1	NUMBER	deprecated - use MGMT_P1
CPU_P2	NUMBER	deprecated - use MGMT_P2
CPU_P3	NUMBER	deprecated - use MGMT_P3
CPU_P4	NUMBER	deprecated - use MGMT_P4
CPU_P5	NUMBER	deprecated - use MGMT_P5
CPU_P6	NUMBER	deprecated - use MGMT_P6
CPU_P7	NUMBER	deprecated - use MGMT_P7
CPU_P8	NUMBER	deprecated - use MGMT_P8
MGMT_P1	NUMBER	first parameter for the resource allocation method
MGMT_P2	NUMBER	second parameter for the resource allocation method
MGMT_P3	NUMBER	third parameter for the resource allocation method
MGMT_P4	NUMBER	fourth parameter for the resource allocation method
MGMT_P5	NUMBER	fifth parameter for the resource allocation method
NAME	TYPE	COMMENTS
MGMT_P6	NUMBER	sixth parameter for the resource allocation method
MGMT_P7	NUMBER	seventh parameter for the resource allocation method
MGMT_P8	NUMBER	eight parameter for the resource allocation method
ACTIVE_SESS_POOL_P1	NUMBER	first parameter for the maximum active sessions target resou
QUEUEING_P1	NUMBER	first parameter for the queueing method
PARALLEL_DEGREE_LIMIT_P1	NUMBER	first parameter for the parallel degree limit resource alloc
SWITCH_GROUP	VARCHAR2	group to switch to once switch time is reached
SWITCH_FOR_CALL	VARCHAR2	switch back to initial consumer group once top call has comp
SWITCH_TIME	NUMBER	switch time limit for execution within a group
SWITCH_IO_MEGABYTES	NUMBER	maximum megabytes of I/O within a group
SWITCH_IO_REQS	NUMBER	maximum I/O requests within a group
SWITCH_ESTIMATE	VARCHAR2	use execution estimate to determine group?
MAX_EST_EXEC_TIME	NUMBER	use of maximum estimated execution time
UNDO_POOL	NUMBER	maximum undo allocation for consumer groups
MAX_IDLE_TIME	NUMBER	maximum idle time
MAX_IDLE_BLOCKER_TIME	NUMBER	maximum idle time when blocking other sessions
NAME	TYPE	COMMENTS
MAX_UTILIZATION_LIMIT	NUMBER	maximum resource utilization allowed, expressed in percentag
SWITCH_TIME_IN_CALL	NUMBER	deprecated - use SWITCH_FOR_CALL and SWITCH_TIME
COMMENTS	VARCHAR2	Text comment on the plan directive
STATUS	VARCHAR2	PENDING if it is part of the pending area, NULL otherwise
MANDATORY	VARCHAR2	Whether the plan directive is mandatory

sys@WORKFLOW>@mydesc.sql
Enter value for table_name: DBA_RSRC_PLANS
Enter value for owner: SYS

NAME	TYPE	COMMENTS
PLAN_ID	NUMBER	Plan ID
PLAN	VARCHAR2	Plan name
NUM_PLAN_DIRECTIVES	NUMBER	Number of plan directives for the plan
CPU_METHOD	VARCHAR2	deprecated - use MGMT_METHOD
MGMT_METHOD	VARCHAR2	resource allocation method for the plan
ACTIVE_SESS_POOL_MTH	VARCHAR2	maximum active sessions target resource allocation method fo
PARALLEL_DEGREE_LIMIT_MTH	VARCHAR2	parallel degree limit resource allocation method for the pla
QUEUEING_MTH	VARCHAR2	queueing method for groups
SUB_PLAN	VARCHAR2	Whether the plan is a sub-plan
COMMENTS	VARCHAR2	Text comment on the plan
STATUS	VARCHAR2	PENDING if it is part of the pending area, NULL otherwise
MANDATORY	VARCHAR2	Whether the plan is mandatory

ITPub博客

ORACLE 资源管理总结(-)---相关视图

最新文章