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

Report message to a moderator

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

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 06 16:36:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.