Re: Oracle 8.1.6 on NT -- Memory

Ann,

Check other parameters in init%SID%.ora parameter file (such as db_block_buffers, shared_pool_size, log_buffer, ...) and adjust them according to your requirements.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
ineyman_at_perceptron.com

• Original Message ----- From: "Ann Horton" <ahorton2_at_ix.netcom.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, June 06, 2000 4:29 PM Subject: Re: Oracle 8.1.6 on NT -- Memory

> Thanks for the advice Igor.
>
> I was seeing a "default" SGA size of close to 120MB on my laptop for
Oracle
> 8i Rel 2. Any other suggestions for reducing it are quite welcome. I
need
> to configure it so that it will run Designer 6.
>
> When I was running Oracle 8.0.5 and 7, I could get by with an SGA of about
> 22MB, but it looks like Oracle 8.1.6 will require substantially more.
>
> Ann Horton
>
> At 10:24 AM 6/6/00 -0800, you wrote:
> >If you are not using Java features of Oracle server, you can reduce
> >'java_pool_size' in init%SID%.ora parameter file to minimum value of
> >1048576.
> >By default, it's ~20MB.
> >
> >Igor Neyman, OCP DBA
> >Perceptron, Inc.
> >(734)414-4627
> >ineyman_at_perceptron.com
> >
> >
> >----- Original Message -----
> >To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> >Sent: Tuesday, June 06, 2000 12:24 PM
> >
> >
> >> I have just installed Oracle 8.1.6 on NT 4.0, and I'd like to reduce
the
> >> memory that Oracle is using for it's Java Virtual Machine. I have
heard
> >> that it is possible to do this with 8.1.6.
> >>
> >> Can one have any experience with this? Anything that I should be aware
> >of?
> >>
> >> Ann Horton
> >> Horton Associates, Inc.
> >>
> >> --
> >> Author: Ann Horton
> >> INET: ahorton2_at_ix.netcom.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).
> >
> >--
> >Author: Igor Neyman
> > INET: ineyman_at_perceptron.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).
> >
>
> --
> Author: Ann Horton
> INET: ahorton2_at_ix.netcom.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 Wed Jun 07 2000 - 09:38:52 CDT