ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORACLE 资源管理总结(-)---相关视图

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

原创 Linux操作系统 作者:jodezhu 时间:2012-05-09 13:16:35 0 删除 编辑
sys@WORKFLOW>@mydesc.sql 
Enter value for table_name: DBA_RSRC_CATEGORIES 
Enter value for owner: SYS 

NAMETYPECOMMENTS
NAMEVARCHAR2Consumer group category name
COMMENTSVARCHAR2Text comment on the consumer group category
STATUSVARCHAR2PENDING if it is part of the pending area, NULL otherwise
MANDATORYVARCHAR2Whether 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 

NAMETYPECOMMENTS
GRANTEEVARCHAR2Grantee name
GRANTED_GROUPVARCHAR2consumer group granted to the grantee
GRANT_OPTIONVARCHAR2whether the grantee can grant the privilege to others
INITIAL_GROUPVARCHAR2 

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

NAMETYPECOMMENTS
CONSUMER_GROUP_IDNUMBERconsumer group id
CONSUMER_GROUPVARCHAR2consumer group name
CPU_METHODVARCHAR2deprecated - use MGMT_METHOD
MGMT_METHODVARCHAR2resource allocation method for the consumer group
INTERNAL_USEVARCHAR2Whether the consumer group is for internal use-only
COMMENTSVARCHAR2Text comment on the consumer group
CATEGORYVARCHAR2Category of the consumer group
STATUSVARCHAR2PENDING if it is part of the pending area, NULL otherwise
MANDATORYVARCHAR2Whether the consumer group is mandatory

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

NAMETYPECOMMENTS
ATTRIBUTEVARCHAR2which session attribute to match
VALUEVARCHAR2attribute value
CONSUMER_GROUPVARCHAR2target consumer group name
STATUSVARCHAR2PENDING 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 

NAMETYPECOMMENTS
START_TIMETIMESTAMP(6)start time of the most recent I/O calibration
END_TIMETIMESTAMP(6)end time of the most recent I/O calibration
MAX_IOPSNUMBERmaximum number of data-block read requests that can be susta
MAX_MBPSNUMBERmaximum megabytes per second of maximum-sized read requests
MAX_PMBPSNUMBERmaximum megabytes per second of large I/O requestslarge I/O
LATENCYNUMBERlatency for data-block read requests
NUM_PHYSICAL_DISKSNUMBERnumber 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 

NAMETYPECOMMENTS
GRANTEEVARCHAR2Grantee name
PRIVILEGEVARCHAR2name of the system privilege
ADMIN_OPTIONVARCHAR2whether 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 

NAMETYPECOMMENTS
ATTRIBUTEVARCHAR2session attribute
PRIORITYNUMBERpriority (1 = highest)
STATUSVARCHAR2PENDING 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 

NAMETYPECOMMENTS
PLANVARCHAR2Name of the plan to which this directive belongs
GROUP_OR_SUBPLANVARCHAR2Name of the consumer group/sub-plan referred to
TYPEVARCHAR2Whether GROUP_OR_SUBPLAN refers to a consumer group or a pla
CPU_P1NUMBERdeprecated - use MGMT_P1
CPU_P2NUMBERdeprecated - use MGMT_P2
CPU_P3NUMBERdeprecated - use MGMT_P3
CPU_P4NUMBERdeprecated - use MGMT_P4
CPU_P5NUMBERdeprecated - use MGMT_P5
CPU_P6NUMBERdeprecated - use MGMT_P6
CPU_P7NUMBERdeprecated - use MGMT_P7
CPU_P8NUMBERdeprecated - use MGMT_P8
MGMT_P1NUMBERfirst parameter for the resource allocation method
MGMT_P2NUMBERsecond parameter for the resource allocation method
MGMT_P3NUMBERthird parameter for the resource allocation method
MGMT_P4NUMBERfourth parameter for the resource allocation method
MGMT_P5NUMBERfifth parameter for the resource allocation method
NAMETYPECOMMENTS
MGMT_P6NUMBERsixth parameter for the resource allocation method
MGMT_P7NUMBERseventh parameter for the resource allocation method
MGMT_P8NUMBEReight parameter for the resource allocation method
ACTIVE_SESS_POOL_P1NUMBERfirst parameter for the maximum active sessions target resou
QUEUEING_P1NUMBERfirst parameter for the queueing method
PARALLEL_DEGREE_LIMIT_P1NUMBERfirst parameter for the parallel degree limit resource alloc
SWITCH_GROUPVARCHAR2group to switch to once switch time is reached
SWITCH_FOR_CALLVARCHAR2switch back to initial consumer group once top call has comp
SWITCH_TIMENUMBERswitch time limit for execution within a group
SWITCH_IO_MEGABYTESNUMBERmaximum megabytes of I/O within a group
SWITCH_IO_REQSNUMBERmaximum I/O requests within a group
SWITCH_ESTIMATEVARCHAR2use execution estimate to determine group?
MAX_EST_EXEC_TIMENUMBERuse of maximum estimated execution time
UNDO_POOLNUMBERmaximum undo allocation for consumer groups
MAX_IDLE_TIMENUMBERmaximum idle time
MAX_IDLE_BLOCKER_TIMENUMBERmaximum idle time when blocking other sessions
NAMETYPECOMMENTS
MAX_UTILIZATION_LIMITNUMBERmaximum resource utilization allowed, expressed in percentag
SWITCH_TIME_IN_CALLNUMBERdeprecated - use SWITCH_FOR_CALL and SWITCH_TIME
COMMENTSVARCHAR2Text comment on the plan directive
STATUSVARCHAR2PENDING if it is part of the pending area, NULL otherwise
MANDATORYVARCHAR2Whether the plan directive is mandatory

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

NAMETYPECOMMENTS
PLAN_IDNUMBERPlan ID
PLANVARCHAR2Plan name
NUM_PLAN_DIRECTIVESNUMBERNumber of plan directives for the plan
CPU_METHODVARCHAR2deprecated - use MGMT_METHOD
MGMT_METHODVARCHAR2resource allocation method for the plan
ACTIVE_SESS_POOL_MTHVARCHAR2maximum active sessions target resource allocation method fo
PARALLEL_DEGREE_LIMIT_MTHVARCHAR2parallel degree limit resource allocation method for the pla
QUEUEING_MTHVARCHAR2queueing method for groups
SUB_PLANVARCHAR2Whether the plan is a sub-plan
COMMENTSVARCHAR2Text comment on the plan
STATUSVARCHAR2PENDING if it is part of the pending area, NULL otherwise
MANDATORYVARCHAR2Whether the plan is mandatory


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26844364/viewspace-723128/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: 样式表
请登录后发表评论 登录
全部评论

注册时间:2012-05-09

  • 博文量
    3
  • 访问量
    8323