Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newshub.sdsu.edu!tethys.csu.net!nntp.csufresno.edu!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: Setting Appropriate Resource Costs Date: Mon, 08 Aug 2005 20:09:54 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: sybrandb@hccnet.verwijderdit.nl References: <1123505741.254383.112400@z14g2000cwz.googlegroups.com> X-Newsreader: Forte Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 34 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249117 On 8 Aug 2005 05:55:41 -0700, "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.. 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