Re: Setting Appropriate Resource Costs

nirav wrote:
> Hi Experts,
>
> I want to know how to properly set composite limit for assigning to a
> profile. Oracle docs says:
> "
> Setting Resource Costs
> Each Oracle database server environment has its own characteristics.
> Some system resources can be more valuable in one environment than
> another. Oracle enables you to assign the following resources a weight,
> which then affects their contribution to a total resource cost:
>
> CPU_PER_SESSION
> LOGICAL_READS_PER_SESSION
> CONNECT_TIME
> PRIVATE_SGA.
> "
>
> Here each of the 4 resource is by default having a value 0. If I have
> to assign a value , which values should I assign to each of these 4
> resources? I just don't know which values are reasonable for normal
> OLTP database.
>
> Thx..

They are obsolete and while I have used them from time-to-time they are not particularly easy to set properly.

Basically the approach I have used is, in test, to set some arbitrary low number and see when things break. Then raise it incrementally while performing load testing until I can achieve the anticipated load, plus some extra percentage, and then I draw the line.

Look, as Sybrand suggests, at Resource Management.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)