What all important parameters of the init.ora are supposed to be increased if you want to increase the SGA size ?

In our case, db_block_buffers was changed from 60 to 1000 (std values are 60, 550 & 3500) shared_pool_size was changed from 3.5MB to 9MB (std values are 3.5, 5 & 9MB) open_cursors was changed from 200 to 300 (std values are 200 & 300) db_block_size was changed from 2048 (2K) to 4096 (4K) {at the time of database creation}.
The initial SGA was around 4MB when the server RAM was 32MB and The new SGA was around 13MB when the server RAM was increased to 128MB.

2 comments:

MK Maran said...

Useful Initora info.

Please add more information about init param.

Thanks.
Mani

MK Maran said...

Add more information on Init param and Interview QA tips.

You can check this Oracle Interview QA site:

http://oracle-faq-qa.blogspot.com/