Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SGA is bigger in Oracle 8.1.6 as compared to 8.1.5 or 8.0.4

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

From: Ashish Shah <ar_shah_at_yahoo.com>
Date: Tue, 25 Jul 2000 11:02:53 -0700 (PDT)
Message-Id: <10569.112916@fatcity.com>

 

> 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
> also send the HELP command for other information
> (like subscribing).


Ashish
Toronto, Canada
Received on Tue Jul 25 2000 - 13:02:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US