Re: Another doubt in 9.0.1.0.0 database..

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Thu, 14 Feb 2002 02:24:09 -0800
Message-ID: <F001.0040F3E8.20020214012831@fatcity.com>

>From the performance guide:

"Memory for the shared pool and buffer cache is allocated in units of granules. A granule can be 4 MB or 16 MB, depending on the total size of your SGA at the time of instance startup. If the size of your SGA is less than 128 MB, then the granules are 4 MB in size; otherwise, they are 16 MB."

hth
connor

• Arul kumar <rakumar_at_mahindrabt.com> wrote: > Hi DBAs,
  >
  > While reducing the JAVA_POOL_SIZE in initfile.... ,
  > i observed that
  > minimum it takes 8M and not less than that.
  >
  > If we dont specify this parameter, default value it
  > takes as 20 M !!.
  >
  > If there is no JAVA related stuff in my application
  > / database..., why
  > should i have this space allocated.?
  >
  > Moreover, this space allocation seems to be
  > affecting the PGA size....!!
  >
  > Any suggestions to make it NULL or zero. ??
  >
  > Thank you.
  >
  > regards,
  > Arul.
  >
  >
  

  ---

  
  > Disclaimer
  >
  > This message (including any attachments) contains
  > confidential information intended for a specific
  > individual and purpose, and is protected by law.
  > If you are not the intended recipient, you should
  > delete this message and are hereby notified that
  > any disclosure, copying, or distribution of this
  > message, or the taking of any action based on it,
  > is strictly prohibited.
  >
  >
  

  ---

  
  > Visit us at http://www.mahindrabt.com
  

  ---

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Thu Feb 14 2002 - 04:24:09 CST