Re: Tuning SGA size

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 18 Jul 2004 08:04:56 +0200
Message-ID: <40fa128c$0$3624$626a14ce@news.free.fr>

"Mad_UNIX" <madunix_at_web.de> a écrit dans le message de news:2luh49Ffb17cU1_at_uni-berlin.de...
> Iam trying to calculate the size of the SGA ...
> I want to know which parameters would effect the size of SGA?
> Thanks
>
> "> > I am running Oracle9i rel2 on AIX 5.1 with 2 GB RAM
> > > How much hould I adjust the size of SGA?
> > >
> > > Thanks
> > >
> >
> > I earn 70,000$/year, what car do i buy?
> >
> > --
> > Regards
> > Michel Cadot
> >
> >
>
>

DB_CACHE_SIZE
DB_nK_CACHE_SIZE
DB_KEEP_CACHE_SIZE
DB_RECYCLE_CACHE_SIZE

JAVA_POOL_SIZE
LARGE_POOL_SIZE
LOG_BUFFER
SGA_MAX_SIZE
SHARED_POOL_SIZE
...

And don't forget memory used by server/shadow processes: *_AREA_SIZE
PGA_AGGREGATE_TARGET
...

--
Regards
Michel Cadot

Received on Sun Jul 18 2004 - 01:04:56 CDT