Thread: 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
Chan
OCP7.3/8.0/8i/9i
Sun Certified Sys. Admin
-
Approximate size of the SGA can be
( (db_block_buffers * block size) + shared_pool_size + log_buffers) /.9
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|