OraFAQ Forum: Server Administration » How to decide for a SGA size

Home » RDBMS Server » Server Administration » How to decide for a SGA size (oracle 8i and 11g , Windows2003 Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to decide for a SGA size [message #317392]

Thu, 01 May 2008 00:04

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