Help to check parameters in init.ora

[manoj]

Hi

My name is manoj thakur.I am new to DBA topics.Could you please check
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=4 GB
Hard Disk Size=144 GB

Now could you please tell me whether the following paramters I have
set is correct in init.ora file

shared_pool_size 400 MB is correct or 800 MB is correct

shared_pool_reserved_size=40 MB

pga_aggregate_target=200 MB

sort_area_size= 50 MB is correct or 1 MB is correct

sort_area_retained_size=5 MB

db_block_size=8192(8 KB)

db_cache_size=500 MB

db_cache_advice= OFF

sga_max_size=1536 MBi.e(1.5 GB)

sessions=1000

open_cursors =500

session_cached_cursors=80

processes=800

O/S=WINDOWS 2003 Standard edition

Processors=2 CPU

Tablespace=oracle tablespaces+1 additional tablespace which can grow

Application Size=6.0 MB

Applicated being made=ASP.NET

Could you please check and tell me whether the following parameters in
the init.ora are correct

[fitzj...@cox.net]

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

[manoj]

Dear Team

Well please check the answers to the question mentioned below

how 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?

> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

[fitzj...@cox.net]

> > - Show quoted text -- Hide quoted text -

>
> - Show quoted text -

Install Statspack and generate a report for this system. Then post
that report here.


David Fitzjarrell

[manoj]

Dear Sir

Since right now I dont have any access to SYS user.Is there any other
alternative way I wanted to check whether the parameters I have
mentioned is correct in init.ora.If any other alternative way is
possible could you please tell me?.Also tell me whether the following
parameters are correct?.
Could you please let me know what exactly the details you want from me
so that the parameters should be correct.

[manoj]

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

[fitzj...@cox.net]

You ask a question no one except YOU can answer, and you can't answer
it because you can't, or won't, run a Statspack report to find any
problem areas you may have.


David Fitzjarrell

[fitzj...@cox.net]

When you generate a Statspack report and at least POST it here THEN
someone may be able to assist you. Without that information NO ONE
can tell you what is 'correct' for your system. Period.


David Fitzjarrell

[Sachin Arora]

@Manoj: From the type of questions you are asking, it seems you dont understand the meaning of these parameters.
I suggest you to involve a professional DBA in this work. There is no point you wasting time on this.

[manoj]

Well Thanks Sir,I will generate the Statspack report of my database
and will display it to you in a short while.It will take one day for
me to generate the STATSPACK REPORT.Thank you very much Sir.I am very
much happy to know things from you.

Regards
Thakur manoj

On Mar 26, 7:04 pm, "Sachin Arora" <oraclear...@googlemail.com> wrote:
> @Manoj: From the type of questions you are asking, it seems you dont
> understand the meaning of these parameters.
> I suggest you to involve a professional DBA in this work. There is no point
> you wasting time on this.
>

> On Wed, Mar 26, 2008 at 7:21 PM, fitzjarr...@cox.net <fitzjarr...@cox.net>

[manoj]

Dear Sir

I will generate the statspack report and will display you the
information

Regards
thakur manoj

[jgar the jorrible]

On Mar 27, 12:39 am, manoj <manojwastha...@gmail.com> wrote:
> Dear Sir
>
> I will generate the statspack report and will display you the
> information
>
> Regards
> thakur manoj

Set db_cache_advice to ON and say which exact version you are on.
Search for that parameter at tahiti.oracle.com

jg
--
@home.com is bogus
http://thedailywtf.com/Articles/Youll-Need-to-Come-Downtown.aspx

[manoj]

oracle 9i version

[fitzj...@cox.net]

> > @home.com is bogushttp://thedailywtf.com/Articles/Youll-Need-to-Come-Downtown.aspx- Hide quoted text -

>
> - Show quoted text -

'oracle 9i version' covers quite a bit of territory, from 9.0.1.2
through 9.2.0.8, so which is it you're using? Such information is
reported in the V$VERSION view and in the banner from SQL*Plus at
login.

Don't expect any useful assistance until you post the EXACT VERSION
you are using.


David Fitzjarrell

[manoj]

Dear Team

Please check the version below that I am using

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

Regards
Thakur manoj

On Mar 31, 6:14 pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
> On Mar 31, 2:38 am, manoj <manojwastha...@gmail.com> wrote:
>
>
>
>
>
> > oracle 9i version
>
> > On Mar 29, 5:07 am, jgar the jorrible <joel-ga...@home.com> wrote:
>
> > > On Mar 27, 12:39 am, manoj <manojwastha...@gmail.com> wrote:
>
> > > > Dear Sir
>
> > > > I will generate the statspack report and will display you the
> > > > information
>
> > > > Regards
> > > > thakur manoj
>
> > > Set db_cache_advice to ON and say which exact version you are on.
> > > Search for that parameter at tahiti.oracle.com
>
> > > jg
> > > --

> > > @home.com is bogushttp://thedailywtf.com/Articles/Youll-Need-to-Come-Downtown.aspx-Hide quoted text -

>
> > - Show quoted text -
>
> 'oracle 9i version' covers quite a bit of territory, from 9.0.1.2
> through 9.2.0.8, so which is it you're using?  Such information is
> reported in the V$VERSION view and in the banner from SQL*Plus at
> login.
>
> Don't expect any useful assistance until you post the EXACT VERSION
> you are using.
>

> David Fitzjarrell- Hide quoted text -

[fitzj...@cox.net]

On Apr 1, 1:18 am, manoj <manojwastha...@gmail.com> wrote:
> Dear Team
>
> Please check the version below that I am using
>
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> PL/SQL Release 9.2.0.1.0 - Production
> CORE    9.2.0.1.0       Production
> TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
> NLSRTL Version 9.2.0.1.0 - Production
>
> Regards
> Thakur manoj
>

Is there a somewhat valid reason you're still using a desupported, and
unpatched, version of Oracle? And how do you expect anyone to assess
your system settings without at least a current Statspack report?


David Fitzjarrell

[manoj]

Dear Team

I will submit the Statspack report.I want two days to submit the
STATSPACK Report