Hi There, users for one of our systems have been reporting major performance issues for a few weeks.
I am fairly new to Oracle yet end up being the most experienced person here to deal with it.
The database is on Sun Solaris 5.10
oracle version 9.2.0.8

All tablespaces appear to have plenty space. There is plenty physical space on the server.
One thing i have noticed when comparing with other databases is that the large pool size is set to 0 whereas our other databases are set at either 16MB or 64MB for the large pool. Is this something that could cause the performance issue? I don't really want to meddle with stuff i don't understand but equally i don't have the time to sit and read about it.
Shared Pool 288MB
Buffer Cachew 304MB
Large Pool 0MB
Java Pool 16MB
Total SGA 610.258MB

Any ideas?