Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Message-ID: <43cd8c15-f6ad-4030-bc99-2612ca630bac@q78g2000hsh.googlegroups.com>
Date: Wed, 26 Mar 2008 06:00:43 -0700 (PDT)
Received: by 10.100.163.8 with SMTP id l8mr1581183ane.5.1206536443448; Wed, 26 
	Mar 2008 06:00:43 -0700 (PDT)
In-Reply-To: <7e9f041b-41fa-4e4e-9a39-cccb32ac7a96@8g2000hsu.googlegroups.com>
X-IP: 124.30.235.135
References: <e0e72569-eda9-4a21-bded-165078241ecc@d62g2000hsf.googlegroups.com> 
	<fd1e80ec-b7e3-4871-97c7-639cb0ae5e58@2g2000hsn.googlegroups.com> 
	<b00f4e79-edbe-40b4-9b8e-e599a9f5321e@8g2000hsu.googlegroups.com> 
	<7e9f041b-41fa-4e4e-9a39-cccb32ac7a96@8g2000hsu.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 
	2.0.50727),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 icra-lnx:80 (squid/2.6.STABLE13)
Subject: Re: Help to check parameters in init.ora
From: manoj <manojwastha...@gmail.com>
To: ORACLE_DBA_EXPERTS <ORACLE_DBA_EXPERTS@googlegroups.com>

Could you please let me know whether there is any other alternative
method since I dont have access to SYS user and I dont have privilges
at all to install STATSPACK.
Also request you to provide me the parameters whether they are correct
or not in the init.ora

regards
Thakur manoj

On Mar 26, 5:27=A0pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
> On Mar 26, 4:34=A0am, manoj <manojwastha...@gmail.com> wrote:
>
>
>
>
>
> > Dear Team
>
> > Well please check the answers to the question mentioned below
>
> > =A0how many concurrent sessions do you expect,
> > Ans:20 concurrent sessions
>
> > what sort of transactions are expected,
> > Ans:The transactions are of the bank proposals .When a bank wasnted to
> > provide a loan to the consumer or the customer the customer has to
> > fill up the proposals.These proposals are getting inside the
> > applications which are getting inserted,updated and deleted through
> > the application in the database.The number of transaction coming in a
> > year are in thousands to lakhs from the application.The number of
> > users are 300 and number of tables are 549.well let me tell you that
> > it consists of 10-20 tranxsactions in a day.
>
> > the average size of those transactions,
> > Ans:10 seconds and the sum of the data_length are 205.
>
> > Do tell me if you want any information?
>
> > On Mar 25, 6:29=A0pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:=

>
> > > On Mar 25, 6:09=A0am, manoj <manojwastha...@gmail.com> wrote:
>
> > > > Hi
>
> > > > =A0My name is manoj thakur.I am new to DBA topics.Could you please c=
heck
> > > > whether the following paramters in init.ora are correct.This is OLTP=

> > > > environment.
> > > > Well The question is that
> > > > Suppose my Database Size is 6.5 GB
> > > > RAM SIZE=3D4 GB
> > > > Hard Disk Size=3D144 GB
>
> > > > Now could you please tell me whether the following paramters I have
> > > > set is correct in init.ora file
>
> > > > shared_pool_size =A0400 MB is correct or 800 MB is correct
>
> > > > shared_pool_reserved_size=3D40 MB
>
> > > > pga_aggregate_target=3D200 MB
>
> > > > sort_area_size=3D 50 MB is correct or 1 MB is correct
>
> > > > sort_area_retained_size=3D5 MB
>
> > > > db_block_size=3D8192(8 KB)
>
> > > > db_cache_size=3D500 MB
>
> > > > db_cache_advice=3D OFF
>
> > > > sga_max_size=3D1536 MBi.e(1.5 GB)
>
> > > > sessions=3D1000
>
> > > > open_cursors =3D500
>
> > > > session_cached_cursors=3D80
>
> > > > processes=3D800
>
> > > > O/S=3DWINDOWS 2003 Standard edition
>
> > > > Processors=3D2 CPU
>
> > > > Tablespace=3Doracle tablespaces+1 additional tablespace which can gr=
ow
>
> > > > Application Size=3D6.0 MB
>
> > > > Applicated being made=3DASP.NET
>
> > > > Could you please check and tell me whether the following parameters =
in
> > > > the init.ora are correct
>
> > > No one can answer that question without more information, such as how
> > > many concurrent sessions do you expect, what sort of transactions are
> > > expected, the average size of those transactions, etc.
>
> > > When you can provide that information then someone may be able to
> > > steer you toward some 'reasonable' settings.
>
> > > David Fitzjarrell- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -
>
> Install Statspack and generate a report for this system. =A0Then post
> that report here.
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -