• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 499
  • Last Modified:

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
0
DarrenJackson
Asked:
DarrenJackson
  • 2
  • 2
1 Solution
 
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
 
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
 
DarrenJacksonAuthor Commented:
Mike

Great website thanks will look into this

Cheers
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now