ORACLE 体系结构

col comments format a80

select consumer_group,comments from dba_rsrc_consumer_groups;

select username,initial_rsrc_consumer_group from dba_users;

CONSUMER_GROUP COMMENTS

OTHER_GROUPS consumer group for users not included in any group in the active top-plan

DEFAULT_CONSUMER_GROUP consumer group for users not assigned to any group

SYS_GROUP Group of system sessions

LOW_GROUP Group of low priority sessions

AUTO_TASK_CONSUMER_GROUP System maintenance task consumer group

系统默认创建的用户组

USERNAME INITIAL_RSRC_CONSUMER_GROUP

MY_DATA DEFAULT_CONSUMER_GROUP

TEST DEFAULT_CONSUMER_GROUP

T DEFAULT_CONSUMER_GROUP

MDDATA DEFAULT_CONSUMER_GROUP

DIP DEFAULT_CONSUMER_GROUP

SCOTT DEFAULT_CONSUMER_GROUP

TSMSYS DEFAULT_CONSUMER_GROUP

DBSNMP DEFAULT_CONSUMER_GROUP

SYSMAN DEFAULT_CONSUMER_GROUP

MDSYS DEFAULT_CONSUMER_GROUP

ORDSYS DEFAULT_CONSUMER_GROUP

USERNAME INITIAL_RSRC_CONSUMER_GROUP

CTXSYS DEFAULT_CONSUMER_GROUP

ANONYMOUS DEFAULT_CONSUMER_GROUP

EXFSYS DEFAULT_CONSUMER_GROUP

DMSYS DEFAULT_CONSUMER_GROUP

WMSYS DEFAULT_CONSUMER_GROUP

XDB DEFAULT_CONSUMER_GROUP

ORDPLUGINS DEFAULT_CONSUMER_GROUP

SI_INFORMTN_SCHEMA DEFAULT_CONSUMER_GROUP

OLAPSYS DEFAULT_CONSUMER_GROUP

MGMT_VIEW DEFAULT_CONSUMER_GROUP

SYS SYS_GROUP

USERNAME INITIAL_RSRC_CONSUMER_GROUP

SYSTEM SYS_GROUP

OUTLN DEFAULT_CONSUMER_GROUP

除了 SYS 和 SYSTEM 用户外，其他所有用户默认都是 DEFAULT_CONSUMER_GROUP