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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
