Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setting Appropriate Resource Costs
On 8 Aug 2005 05:55:41 -0700, "nirav" <shivam71_at_gmail.com> 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..
I very much doubt anyone has ever used this composite limit and came
up with something useful.
I also wouldn't be surprised, now Oracle has introduced
resource_plans, these limits will be obsoleted in a future release.
-- Sybrand Bakker, Senior Oracle DBAReceived on Mon Aug 08 2005 - 13:09:54 CDT