Home » RDBMS Server » Server Utilities » stats_pack results
stats_pack results [message #331906] Sun, 06 July 2008 09:43 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Hi to all,

I am using oracle version 10.2.0.4.0 on windows 2003 server. My production database performance is very bad. I have used statspack to analyze the performance.

As i am new to ORACLE i don't know how to analyze the stats report and from the report what i got is to increase the sga and pga.

I don't know how much size i have to increase for sga and pga.

RAM size is 8GB. Here by i have attached my stats pack report.

If any one can help me please.

Thanks & Regards,

Seenu
Re: stats_pack results [message #331909 is a reply to message #331906] Sun, 06 July 2008 09:51 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>I don't know how much size i have to increase for sga and pga.
Double the size of each of them.
Previous Topic: SQL*Loader-466: Column FIELD1 does not exist in table UTENTI.
Next Topic: problem In Import
Goto Forum:
  


Current Time: Fri Dec 02 14:21:41 CST 2016

Total time taken to generate the page: 0.21523 seconds