oracle资源管理器

资源管理器的功能： 1. 可以限制用户使用cpu的百分比 2. 执行语句的并行操作，可以制定多个进程操作 3. 限制活动会话的数量 4. 语句执行时间 5. 限制使用undo空间的大小 6. 限制用户

资源管理器的功能：
1. 可以限制用户使用cpu的百分比
2. 执行语句的并行操作，可以制定多个进程操作
3. 限制活动会话的数量
4. 语句执行时间
5. 限制使用undo空间的大小
6. 限制用户链接的空闲时间
资源管理器的创建
1. 创建资源组
2. 创建资源计划，默认只能使用一个资源计划
3. 编辑资源指令。资源指令就是上面指的资源管理器的所有功能
4. 将资源组下的用户权限更改
5. 启用资源计划
6. 验证资源计划是否可用

创建资源管理器

1    创建资源管理器oem

    emctl start dbconsole

    如果启动不起来需要重新创建一次

    emca -deconfig dbcontrol db -repos drop

[oracle@dghost ~]$ emca -repos dropSTARTED EMCA at Mar 27, 2017 10:13:16 AMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle.  All rights reserved.Enter the following information:Database SID: orclListener port number: 1521Password for SYS user:  Password for SYSMAN user:  ----------------------------------------------------------------------WARNING : While repository is dropped the database will be put in quiesce mode.----------------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: yMar 27, 2017 10:13:50 AM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/oracle/cfgtoollogs/emca/PORCL/emca_2017_03_27_10_13_15.log.Mar 27, 2017 10:13:50 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Dropping the EM repository (this may take a while) ...Mar 27, 2017 10:19:02 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully droppedEnterprise Manager configuration completed successfullyFINISHED EMCA at Mar 27, 2017 10:19:02 AM

    emca -config dbcontrol db -repos create

[oracle@dghost ~]$ emca -config dbcontrol db -repos createSTARTED EMCA at Mar 27, 2017 10:21:14 AMEM Configuration Assistant, Version 11.2.0.3.0 ProductionCopyright (c) 2003, 2011, Oracle.  All rights reserved.Enter the following information:Database SID: orclListener port number: 1521Listener ORACLE_HOME [ /u01/oracle/11g ]: Password for SYS user:  Password for DBSNMP user:  Password for SYSMAN user:  Password for SYSMAN user: Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): -----------------------------------------------------------------You have specified the following settingsDatabase ORACLE_HOME ................ /u01/oracle/11gLocal hostname ................ dghostListener ORACLE_HOME ................ /u01/oracle/11gListener port number ................ 1521Database SID ................ orclEmail address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... -----------------------------------------------------------------Do you wish to continue? [yes(Y)/no(N)]: yMar 27, 2017 10:21:45 AM oracle.sysman.emcp.EMConfig performINFO: This operation is being logged at /u01/oracle/cfgtoollogs/emca/PORCL/emca_2017_03_27_10_21_12.log.Mar 27, 2017 10:21:47 AM oracle.sysman.emcp.EMReposConfig createRepositoryINFO: Creating the EM repository (this may take a while) ...Mar 27, 2017 10:32:45 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Repository successfully createdMar 27, 2017 10:32:56 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepositoryINFO: Uploading configuration data to EM repository (this may take a while) ...Mar 27, 2017 10:34:38 AM oracle.sysman.emcp.EMReposConfig invokeINFO: Uploaded configuration data successfullyMar 27, 2017 10:34:46 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Securing Database Control (this may take a while) ...Mar 27, 2017 10:35:01 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsoleINFO: Database Control secured successfully.Mar 27, 2017 10:35:01 AM oracle.sysman.emcp.util.DBControlUtil startOMSINFO: Starting Database Control (this may take a while) ...Mar 27, 2017 10:36:19 AM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: Database Control started successfullyMar 27, 2017 10:36:19 AM oracle.sysman.emcp.EMDBPostConfig performConfigurationINFO: >>>>>>>>>>> The Database Control URL is https://dghost:5500/em <<<<<<<<<<<Mar 27, 2017 10:36:26 AM oracle.sysman.emcp.EMDBPostConfig invokeWARNING: ************************  WARNING  ************************Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/oracle/11g/dghost_PORCL/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost. ***********************************************************Enterprise Manager configuration completed successfullyFINISHED EMCA at Mar 27, 2017 10:36:26 AM[oracle@dghost ~]$ emctl status dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.https://dghost:5500/em/console/aboutApplicationOracle Enterprise Manager 11g is running. ------------------------------------------------------------------Logs are generated in directory /u01/oracle/11g/dghost_PORCL/sysman/log 

登录

里面创建计划组等.