RE: TYT Oracle 8i Bible Question: Effect of Large_Pool

From: Maser, Donna (SEA) <DonnaMaser_at_chiroscience.com>
Date: Tue, 14 Nov 2000 13:49:59 -0800
Message-Id: <10680.122052@fatcity.com>

I believe you can set it to 0 ONLY if you are on 8.1.6 or above. With 8.1.5 I think the minimum is 1 M.
- Donna

-----Original Message-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com] Sent: Tuesday, November 14, 2000 1:34 PM To: Multiple recipients of list ORACLE-L Subject: Re: TYT Oracle 8i Bible Question: Effect of Large_Pool_Size o...

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.

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


The information contained in this email is intended for the
personal and confidential use of the addressee only. It may
also be privileged information. If you are not the intended
recipient then you are hereby notified that you have received
this document in error and that any review, distribution or
copying of this document is strictly prohibited. If you have
received  this communication in error, please notify Celltech
Group immediately on:

+44 (0)1753 534655, or email 'is_at_celltech.co.uk'

Received on Tue Nov 14 2000 - 15:49:59 CST

RE: TYT Oracle 8i Bible Question: Effect of Large_Pool_Size o...