|
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...
|
- Re: Memory Sizing Stuart Graham
- Re: Memory Sizing Yosi Greenfield
