Originally posted by st2000
I think we can see this will cause I/O and CPU resources to be used.If the value is set too high, swapping will began to occur on the OS and the system may come to a halt.

-------

In the last sentence, where it says, value high or low, I believe it should be low...

No, the sentance is correct. If your db_block_buffers is too large, it will consume lots of real memory thereby forcing you to swap.

What are the effects, if we have too much SGA allocation?

You will swap processes out to disk. Since disk is much slower than RAM, your performance will suffer.

My parameters are all looking good, but system is Paging and swapping at 40%. Is it good or bad or normal..
I try to avoid any swapping.