Re: SGA

From: Roel Toledo <dontsendmailstome_at_bogusmail.com>
Date: Tue, 30 Oct 2001 21:56:05 GMT
Message-ID: <VlFD7.90222$WW.4997580@bgtnsc05-news.ops.worldnet.att.net>

"Félix" <fgaitero_at_e-netfinger.com> wrote in message news:9rmqj0$rfq$1_at_talia.mad.ttd.net...
> I would like to know how to increase my SGA size because I got problems
when
> I'm working with Oracle Designer/2000
> Thanks
> Félix

You increase the SGA size by increasing the individual components that make up the SGA: shared pool, data buffer cache and redo log buffer. You need to run utlbstat/utletsat on your server to determine if these areas on your sga are inadequately sized. Also, you need to read a whole chapter on database performance tuning to effectively size these memory components of your SGA. Received on Tue Oct 30 2001 - 15:56:05 CST