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                70924
Variable Size           9756672
Database Buffers        2048000
Redo Buffers              77824
 
SQL> SELECT pool,
  2         SUM(bytes)
  3    FROM v$sgastat
  4   GROUP BY pool;
 
POOL        SUM(BYTES)
----------- ----------
java pool        32768
large pool      614400
shared 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...

Reply via email to