Re: SGA

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 23 Sep 2002 00:24:29 +0200
Message-ID: <uot69n4abc7gbd@corp.supernews.com>

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3d8e2c92$2_2_at_mk-nntp-1.news.uk.worldonline.com...
> "xueyang" <xueyangy_at_singnet.com.sg> wrote in message
> news:amc8ju$vha$1_at_mawar.singnet.com.sg...
> > One simple question, Is it the larger the size of SGA is, the better
> > performance we get?
> >
> >
> One simple answer: NO
>
>

A colleague has seen an instance where the entire database fitted in SGA. As no sufficient RAM was available, the performance was still abysmal.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Sun Sep 22 2002 - 17:24:29 CDT