sga

hello,
pl confirm -
if sga=shared pool size+db_block_buffer*db_block_size+log_buffer
+ some extra for mts structures
am I right?
i have 512 mb ram and show sga-
Total System Global Area 600481740 bytes
Fixed Size 65484 bytes
Variable Size 343617536 bytes
Database Buffers 256544768 bytes
Redo Buffers 253952 bytes
i think i set shared pool to much larger than I should and also increased db_block_buffers much more.am I sure?
in this scenario ,if the bg proceses like snp0 ,dbwr and lgwr will get dead?as I am getting this error.

query the v$sgastat for details on mem allocation in the SGA...The POOL column will tell you in which pool (large or shared ) that allocation is, the NAME will tel u the name of the vuffer and the BYTES column will tell the size...check it out...

Hi
You have 512MB RAM and ur SGA is 600MB.Reduce your SGA size.If u have other applications as well running the system will come down and u will get errors.

hello,
I dont have any other application running in server.but at client end d2k is running.i reduced the sga size?but my original question regarding sga remained unanswerd.
can u tell that.I dont have any book right now to see .

Hi Drishti,

When you size your SGA out of physical memory paging and swapping will occur.

For start size your SGA at around 65% of your physical memory to allow some memory for the OS.

Did the problem already existed before the enlargement of the memory structures?

Tycho

what error you were getting? drishti

Approximate size of the SGA can be

( (db_block_buffers * block size) + shared_pool_size + log_buffers) /.9