Oracle user PROFILE limits
Environment: Windows 2003, Oracle 10g
What numbers are going to b reasonable for me to use to create a profile so as to assign it to my regular users and report users in order to restrict them to not eat all the resources like CPU and memory.
The default profile used by users is 'DEFAULT' which has 'unlimited' limits. I am mainly looking good numbers for
sessions_per_user
cpu_per_session
cpu_per_call
connect_time
logical_reads_per_session unlimited
logical_reads_per_call unlimited
composite_limit unlimited
private_sga unlimited
Currently I have create one like this:
----------------------------------
create profile ABC limit
sessions_per_user unlimited
cpu_per_session 720000
cpu_per_call unlimited
connect_time unlimited
idle_time 60
logical_reads_per_session unlimited
logical_reads_per_call unlimited
composite_limit unlimited
private_sga unlimited
failed_login_attempts 10
password_life_time unlimited
password_reuse_time unlimited
password_reuse_max unlimited
password_lock_time unlimited
password_grace_time unlimited;
-D
