Home » RDBMS Server » Performance Tuning » Increasing the SGA size
Increasing the SGA size [message #187073] Thu, 10 August 2006 14:59 Go to next message
pankajwc
Messages: 4
Registered: August 2006
Junior Member
I have Oracle 9i Release 2 running on Server with 4 GB RAM and I was facing frequent TNS Internal Limit exceeded problem. I converted the server on Shared mode and now the problem has resolved.

But I am facing a another problem SGA is restricted to just 1.4 GB of RAM and the system is having only Oracle 9i on it.

How do I increase the SGA size to increase the performance ?

The database was configured by the previous DBA who has left.

Please help me.

Pankaj
Re: Increasing the SGA size [message #187258 is a reply to message #187073] Fri, 11 August 2006 09:15 Go to previous messageGo to next message
michael_bialik
Messages: 621
Registered: July 2006
Senior Member
Why do you think that SGA increment will improve your application performance?
Re: Increasing the SGA size [message #187267 is a reply to message #187258] Fri, 11 August 2006 09:44 Go to previous messageGo to next message
pankajwc
Messages: 4
Registered: August 2006
Junior Member
My buffer cache hit ratio is very low 50-60 percent.

But when I try to increase the size of the SGA is says insufficient memory.

I have 4 GB RAM and Total system including 1.39 GB used by Oracle is not more than 1.6 GB.

How do I optimize it ?


Thanks in advance.

warm regards,

Pankaj
Re: Increasing the SGA size [message #187272 is a reply to message #187073] Fri, 11 August 2006 10:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>My buffer cache hit ratio
BCHR is a meaningless indicator of performance.
Re: Increasing the SGA size [message #187336 is a reply to message #187073] Sat, 12 August 2006 04:52 Go to previous messageGo to next message
michael_bialik
Messages: 621
Registered: July 2006
Senior Member
Try tuning your SQL statements first ( before increasing SGA )

Re: Increasing the SGA size [message #187339 is a reply to message #187336] Sat, 12 August 2006 05:06 Go to previous messageGo to next message
pankajwc
Messages: 4
Registered: August 2006
Junior Member
I am new to Programming PL/SQL. can you suggest some decent tool for doing it?

warm regards,

Pankaj
Re: Increasing the SGA size [message #187408 is a reply to message #187073] Sun, 13 August 2006 13:20 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You could start by reading & understaning the fine Database Performance and Tuning Guide found at
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm

[Updated on: Sun, 13 August 2006 16:49] by Moderator

Report message to a moderator

Previous Topic: Query tuning
Next Topic: Compund index vs simple index
Goto Forum:
  


Current Time: Fri Mar 29 08:23:50 CDT 2024