通过user profile限制管理帐号的资源使用

通过user profile限制管理帐号的资源使用，

create profile admin_user limit

sessions_per_user 50

cpu_per_session unlimited

cpu_per_call 3000

connect_time 30

idle_time 20

logical_reads_per_session default

logical_reads_per_call 1000;

alter user admin profile admin_user;

alter system set resource_limit=true scope=both;

每个参数的含义如下

[@more@]

How To Calculate The Blocks Used In A Query To Configure LOGICAL_READS_PER_CALL [ID 872133.1]

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

转载于:http://blog.itpub.net/668365/viewspace-1029854/