管理安全和资源（四）--资源管理器的使用

1、资源管理，启用参数

09:44:54 SQL> show  parameter resource

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

resource_limit                       boolean     FALSE

resource_manager_plan                string

09:51:22 SQL> alter system set resource_limit=true;

System altered.

09:51:39 SQL> show  parameter resource

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

resource_limit                       boolean     TRUE

resource_manager_plan                string

2、资源管理分类

1）基于会话

2）基于语句

09:56:24 SQL> create profile res_profile limit

09:56:26   2   SESSIONS_PER_USER 2;

Profile created.

验证：

09:56:39 SQL> alter user tom profile res_profile;

User altered.

09:56:57 SQL> conn tom/tom

Connected.

09:57:09 SQL> conn tom/tom

Connected.

09:57:17 SQL> conn tom/tom

ERROR:

ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Warning: You are no longer connected to ORACLE.