Re: Memory Sizing

[Yosi Greenfield]

Did you maybe use a different init file? Did you check the
parameters in your email from sql or from the init file you
think you're using to start the database?

Just a sanity check, I'm sure you did all the right things...



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Memory Sizing

[Stuart Graham]

All, I have a question re Sizing of various 
memory areas in the SGA.
 
On a test box (8.1.6.0.0 NT4), I have a 
database with the following init.ora parameters...
 
db_block_buffers = 500
 
shared_pool_size = 4951040
 
large_pool_size = 614400
java_pool_size = 0
 
log_buffer = 32768
 
db_block_size = 4096
 
However, querying v$sga and v$sgastat gives 
some different results...
 
 
SQL> SELECT *  
2    FROM v$sga;
 
NAME  
VALUE --Fixed 
Size    
70924Variable 
Size   
9756672Database Buffers    
2048000Redo 
Buffers  
77824
 
SQL> SELECT pool,  
2 SUM(bytes)  
3    FROM v$sgastat  4   GROUP BY 
pool;
 
POOL    SUM(BYTES)--- 
--java pool    32768large 
pool  614400shared pool    
9091800   
2185484
 
As you can see, only my database buffers 
seem to match what was specified in the init.ora
The redo buffers are equal to 
(log_buffer*2)+ 1 block.
The shared pool bears no resemblance to 
shared_pool_size!!
 
Thanks in 
advance...