Here is a snapshot of my SGA:
Total System Global Area 419430400 bytes
Fixed Size 1979168 bytes
Variable Size 318770400 bytes
Database Buffers 92274688 bytes
Redo Buffers 6406144 bytes
Other than shared_pool_size, java_pool and large_pool is there any other
initializtion variable that controls the size of the variable size.
SQL> select sum(bytes) from v$sgastat where pool = 'shared pool';
SUM(BYTES)
----------
79696632
SQL> select sum(bytes) from v$sgastat where pool = 'java pool';
SUM(BYTES)
----------
33554432
SQL> select sum(bytes) from v$sgastat where pool = 'large pool';
SUM(BYTES)
----------
8388608
I am thinking there must be since the values don't add up to 318770400.
Is there something else that goes into computation of variable size. Note:
I am trying to make this DB use less memory and I am looking where I can
start.
Thanks