| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
> >
> >
 |
 |