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