What about JAVA_POOL_SIZE ?
- Original Message -----
From: "Rachel Carmichael" <carmichr_at_hotmail.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, November 14, 2000 5:55 AM
Subject: Re: TYT Oracle 8i Bible Question: Effect of Large_Pool_Size o...
> 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).
Received on Tue Nov 14 2000 - 12:36:43 CST
