Thanks all for the information. I am not using Java in the database so I
will be able to decrease the SGA size.
Regards
Long
-----Original Message-----
From: Ashish Shah [mailto:ar_shah_at_yahoo.com]
Sent: Tuesday, 25 July 2000 7:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: SGA is bigger in Oracle 8.1.6 as compared to 8.1.5 or 8.0.4
Hi Steve,
Can I reduce java_pool_size to 0M?
We are using java applications which connect to
oracle 8.1.6 but we are not using webdb.. It's
all written outside oracle. We are just
using database as repository.
Let me know how java_pool_size is going to help me..
Thanks
- Steve Adams <steve.adams_at_ixora.com.au> wrote:
> 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-----
> Long
> Sent: Monday, 24 July 2000 17:44
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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).
> --
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.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).
Ashish
Toronto, Canada
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
--
Author: Ashish Shah
INET: ar_shah_at_yahoo.com
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
Received on Mon Jul 24 2000 - 18:31:36 CDT
