Help - Search - Members - Calendar
Full Version: resource limit
Oracle DBA Forums > Oracle > Oracle Forum
saagar
hi

want to set 3 profiles

POWERUSER

REPORTDESIGNER

REPORTVIEWER

where 1st profile poweruser wil have highest profile ...resources
2nd reportdesigner will have slightly lower resources compare to poweruser
3rd reportviewer will have lower resources compare to reportdesigner...

so how would be my approach....

my hardware is 2.20GHz and 2BD RAM AND HDD is 200GB and Oracle is 10.2

Kindly help me how would be my approach ........


CHeers
dave
use the database resource manager then
saagar
hi

the parameters mentioned you in this page are all in bytes ???

http://www.dba-oracle.com/t_resource_profiles.htm


CREATE PROFILE enduser LIMIT
CPU_PER_SESSION 60000--------bytes
LOGICAL_READS_PER_SESSION 1000---------------bytes
CONNECT_TIME 30-------mins
PRIVATE_SGA 102400---------------bytes
CPU_PER_CALL UNLIMITED
COMPOSITE LIMIT 60000000---------bytes
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LIFE_TIME 90
PASSWORD_REUSE_TIME 180
PASSWORD_LOCK_TIME 3
PASSWORD_GRACE_TIME 3

kindly mention the ideal values for above profile........

CHeers
SteveC
Ideal for whom? You or me? This is a judgment call on your part. How do you want to rank the users (other than the A>B>C) model you stated? 60-30-10? 45-35-20? For other parameters, there is no ideal, there is only what you want to apply.
burleson
>> kindly mention the ideal values for above profile........

OK, how about NONE. Remember, the sole purpose of resource profiles is to interrupt the end-user and abort their task. If you need more resources, get them, just IMHO!:

POWERUSER - No profile, no limit

REPORTDESIGNER

CREATE PROFILE reportdesigner LIMIT
CPU_PER_SESSION unlimited
LOGICAL_READS_PER_SESSION 1024576
CONNECT_TIME 30-------mins
PRIVATE_SGA 1024576
CPU_PER_CALL UNLIMITED
COMPOSITE LIMIT 60000000---------bytes
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LIFE_TIME 90
PASSWORD_REUSE_TIME 180
PASSWORD_LOCK_TIME 3
PASSWORD_GRACE_TIME 3


REPORTVIEWER

CREATE PROFILE reportviewer LIMIT
CPU_PER_SESSION unlimited
LOGICAL_READS_PER_SESSION 1024576
CONNECT_TIME 30-------mins
PRIVATE_SGA 1024576
CPU_PER_CALL UNLIMITED
COMPOSITE LIMIT 60000000---------bytes
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LIFE_TIME 90
PASSWORD_REUSE_TIME 180
PASSWORD_LOCK_TIME 3
PASSWORD_GRACE_TIME 3
saagar
hi

thank you burleson ....very much

but when i create it ...it gives me error....

SQL> create profile poweruser limit
2 sessions_per_user unlimited,
3 cpu_per_session unlimited,
4 cpu_per_call 30000,
5 connect_time 60,
6 logical_reads_per_session unlimited,
7 logical_reads_per_call unlimited,
8 composite limit 5000000;
sessions_per_user unlimited,
*
ERROR at line 2:
ORA-02376: invalid or redundant resource

which is the view where i can see that these are limits given to this profile and how i can see profiles in my database ???

CHeers
burleson
>> where i can see that these are limits given to this profile and how i can see profiles in my database ???

How about where you spammed it?

http://forums.oracle.com/forums/thread.jsp...50&tstart=0
saagar
spammed it means .......

i didnt get you ...burleson...

regards
burleson
>> spammed it means .......

You posted the exact same question to many forums.

Do you think that's a nice thing to do?
saagar
hi

No thats not a nice thing

i am very sorry

but taking different views was the only intention from it

from next time i wont be doing this ......

SOrry once again

CHeers
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.