Oracle user PROFILE limits

[daljitsb]

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

[davey23uk]

totally depends on what queries they are going to run

[PAVB]

Run explain plan for what you consider the more expensive queries your users might run and start by setting limits twice the larger values you have found.

Over time you might have to fine tune limit values to accomodate real world situations.