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
mohdmujtaba
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.
Thanx

Mohammed
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: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Performance Tuning Guide
Chapter 7 Memory Configuration and Use

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


Current Time: Wed Dec 07 09:02:39 CST 2016

Total time taken to generate the page: 0.13526 seconds