Please make sure SGA_MAX_SIZE works on your h/w platform. It does not work on AIX as advertised,
and I think Sun Solaris needs some tweaking (related to ISM use) to make it work.
- Kirti
- Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
> > In 9202, DB_BUBBER_CACHE, SHARED_POOL, LARGE_POOL
> > and JAVA_POOL can be dynamically altered. But in 901, LARGE_POOL
> > and JAVA POOL are static. If MAX SGA is less than 128MB then Oracle
> > will use 4MB granule size to allocate/deallocate memory. For SGA greater
> > than 128M, Oracle granule size is 16MB.
>
> Btw, in Windows the granule size is 8M if SGA_MAX_SIZE is set larger than
> 128M.
>
> Note that there's more stuff in SGA than above mentioned areas. Fixed SGA
> for example etc..
>
> Tanel.
>
>
> >
> > -----Original Message-----
> > To: Multiple recipients of list ORACLE-L
> > Sent: 9/20/03 11:19 AM
> >
> >
> >
> > My understanding of SGA is
> > SGA = x + y + z
> > where x = (dbblksize*db_blk_buf OR db_cache_Size if 9i)
> > y=shared_pool
> > z=java pool, log_buffer
> >
> > If 9i oracle introduced SGA_MAX_SIZE; the sum of x+y+z can be
> > < SGA_MAX_SIZE; if so, which part of x/y/z expands when need arises.
> >
> > Thanks
> >
> > Quriyat
> >
> >
> >
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: kirtikumar_deshpande_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Sep 22 2003 - 10:54:47 CDT
