Oracle Management Security and resources (iv) Use of Oracle Resource Manager

1, resource management, enabling parameters

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. Resource Management classification

1) based on session

2) based on statement

09:56:24 sql> Create profile Res_profile limit

09:56:26 2 Sessions_per_user 2;

Profile created.

Verify:

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.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/