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: 63911
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: Sun Oct 23 04:40:27 CDT 2016

Total time taken to generate the page: 0.07880 seconds