sga

[drishti]

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.

[siroracle]

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...

[raghucharan]

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.

[drishti]

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 .

[tycho]

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

[Chandra]

what error you were getting? drishti

[raghucharan]

Approximate size of the SGA can be

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