good point -- depends on what version of Oracle you are running, and you CAN
set it to 0 if you are not using Java in the database.
>From: "Al Glazunov" <mcti_at_aicompro.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: TYT Oracle 8i Bible Question: Effect of Large_Pool_Size o...
>Date: Tue, 14 Nov 2000 10:36:17 -0800
>
>What about JAVA_POOL_SIZE ?
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Tuesday, November 14, 2000 5:55 AM
>
>
> > Hannah,
> >
> > Not quite....
> >
> >
> > >Ok, here's my question: There are a few paramters that greatly impact
>the
> > >overall size of the SGA:
> > >
> > >A: db_block_size
> > >B: db_block_buffers
> > >C: log_buffer
> > >D: shared_pool_size
> > >E: large_pool_size
> > >
> > >In order to calculate the overall size of the SGA , would you: A * (B +
>C
>+
> > >D + E) ?
> > >
> >
> > C, D and E are expressed in exact size in bytes, not Oracle blocks so
>the
> > calculation should be:
> >
> > (A * B) + C + D + E
> >
> >
> > >what is the calculation used by SQL Plus when you use the SHOW command
>with
> > >the
> > >SGA clause? (BTW, I did not see that the
> > >SGA clause was available in 7.3.4, looks like its only supported in
>8i).
> > >
> >
> > I believe it's the above calculation that's used, but I am sure that
>someone
> > here will correct me if I am wrong
> >
> > show sga is available in 7.3.4 but not through SQL*Plus, only through
> > svrmgrl -- just tried it on my 7.3.4 db. Same for 8.0 It's only with
>8i
> > that you can use sqlplus to start/stop the database so it makes sense
>that
> > the command is not available in sqlplus until then.
> >
> >
>_________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
>http://www.hotmail.com.
> >
> > Share information about yourself, create your own public profile at
> > http://profiles.msn.com.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.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).
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Al Glazunov
> INET: mcti_at_aicompro.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).
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
Received on Tue Nov 14 2000 - 15:26:40 CST
