Home » RDBMS Server » Server Administration » How to decide for a SGA size (oracle 8i and 11g , Windows2003 Server)
How to decide for a SGA size [message #317392] Thu, 01 May 2008 00:04 Go to next message
Messages: 2
Registered: April 2008
Location: Pune
Junior Member
Hi ,
I m Mohammed Mujtaba Khan , I wanted to know how to decide for a SGA size , I mean how much memory should be allocated som as to get the max performance ,
in 11g I tried to mention sga_target=3g , its giving error ora-02097 and out of memory
at present my sga_max_size=512mb
at present my sga_target=512mb

my RAM is 0f 16GB
and HDD caopacity is 1TB
please do suggect me.

Re: How to decide for a SGA size [message #317398 is a reply to message #317392] Thu, 01 May 2008 01:00 Go to previous message
Michel Cadot
Messages: 65089
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Performance Tuning Guide
Chapter 7 Memory Configuration and Use

Previous Topic: action taken on scatterds read
Next Topic: Table size not visible
Goto Forum:

Current Time: Thu Jul 27 02:32:22 CDT 2017

Total time taken to generate the page: 0.05949 seconds