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

From: Cunningham, Gerald <Gerald.Cunningham_at_usi.net>
Date: Wed, 15 Nov 2000 12:43:12 -0500
Message-Id: <10681.122137@fatcity.com>

I think the missing bytes are the "fixed size" and are unconfigurable / set by Oracle.

I demand a byte recount (by hand)!!

-----Original Message-----
From: Al Glazunov [mailto:mcti_at_aicompro.com] Sent: Tuesday, November 14, 2000 3:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: TYT Oracle 8i Bible Question: Effect of Large_Pool_Size o...

Hi Gurus,
Sorry to bother you, but I'd like to make it straight:

I have it checked on my development server and found the following numbers:

(db_block_size          integer             8192)
(db_block_buffers     integer           26362)
                                             215,957,504 bytes
 large_pool_size         string          614,400
 log_buffer                integer           32768
 shared_pool_size       string     71,986,176
 java_pool_size           string     20,971,520
 -------------------------------------------------
 Total                                 309,562,368

SQL> show sga;
Total System Global Area 315,675,916 bytes

Fixed Size                                    70924 bytes
Variable size                         99,569,664 bytes
Database Buffers                  215957504 bytes
Redo Buffers                               77824 bytes

Total System Global Area is reported as large as 315,675,916 bytes and total from the formula makes 309,562,368 so I'm still missing 6,113,548 bytes

Anybody have an idea?

Thank you,
Alex

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

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

Received on Wed Nov 15 2000 - 11:43:12 CST

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