Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Setting Appropriate Resource Costs

Re: Setting Appropriate Resource Costs

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 08 Aug 2005 20:09:54 +0200
Message-ID: <as7ff1tspl5j3o5v7ot4oo0fkr3vrksint@4ax.com>


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 DBA
Received on Mon Aug 08 2005 - 13:09:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US