RE: SGA is bigger in Oracle 8.1.6 as compared to 8.1.5 or 8.0.4

Hello Long,

8.1.x has a 20M Java pool by default, but 8.1.5 does not make it visible. If you are not using Java in the database explicitly, it is safe to reduce the java_pool_size to 1M.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Nguyen, Long
Sent: Monday, 24 July 2000 17:44
To: Multiple recipients of list ORACLE-L Subject: SGA is bigger in Oracle 8.1.6 as compared to 8.1.5 or 8.0.4

Hi,

I have just upgraded some databases from 804 and 815 to 816 on Solaris. After the upgrade I notice that the SGA of each db is about 24MB bigger although I have not changed the size of db buffer, shared pool or redo logs
(basically the same init.ora file with a few obsolete parameters removed).
"show sga" under svrmgrl indicates that the change is in the variable part of the SGA.

Anyone observes the same thing? Any way that I can reduce the memory allocation to the variable part of teh SGA?

Long

-- 
Author: Nguyen, Long
  INET: Long.Nguyen_at_its.csiro.au

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).