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

Report message to a moderator

Re: stats_pack results [message #331909 is a reply to message #331906] Sun, 06 July 2008 09:51 Go to previous message
BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic: SQL*Loader-466: Column FIELD1 does not exist in table UTENTI.
Next Topic: problem In Import
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 11 15:26:14 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.