Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail
From: "nirav" <shivam71@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Setting Appropriate Resource Costs
Date: 8 Aug 2005 05:55:41 -0700
Organization: http://groups.google.com
Lines: 24
Message-ID: <1123505741.254383.112400@z14g2000cwz.googlegroups.com>
NNTP-Posting-Host: 203.197.254.126
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1123505746 32750 127.0.0.1 (8 Aug 2005 12:55:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 8 Aug 2005 12:55:46 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=203.197.254.126;
   posting-account=EIIp9Q0AAABx3TtORI4efSnWEZQGHNCc
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249090

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..