Performance Issues

Guys
I am the DB for an oracle database of around 200 users recently I have been getting people phoning me complaining of the database running slow. This seems to occur randomly but often on the afternoon.
I use an Oracle 9I database running on windows 2000 advanced server with 8 GB of memory
Shared Pool = 456mb
Buffer cache = 104mb
java pool = 32mb
SGA Max Size = 657mb
The PGA Settings are I believe handled automatically as I have the WORKAREA_SIZE_POLICY = AUTO
But it does have PGA Aggregate = 70mb
I have set 2 groups of 5 undo logs over 2 harddisks each 40mb in size.

what I would like to know is are the above settings to high or too low as I seem to get conflicting issues over this.

Any help would be great

Cheers

Darren
DarrenJacksonAsked:
Who is Participating?
 
MikeOM_DBACommented:

By "Analyzed" I mean you periodically use the DBMS_STATS package (or the ANALYZE statement) to gather optimizer statistics.

For help in interpreting the statspack report go to: http://www.txmemsys.com/statspack-reg.htm
0
 
MikeOM_DBACommented:

First of all check if your tables are ANALYZED.

Then you could instal the DBMS_STATSPACK package:

http://www.oracle.com/technology/deploy/performance/pdf/statspack_opm4.pdf
0
 
DarrenJacksonAuthor Commented:
Mike

not sure what you mean by analyzed but I have stats pack in stalled and have taken a snapshot of todays database performance issue
0
 
DarrenJacksonAuthor Commented:
Mike

Great website thanks will look into this

Cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.