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:
Useful Initora info.
Please add more information about init param.
Thanks.
Mani
Add more information on Init param and Interview QA tips.
You can check this Oracle Interview QA site:
http://oracle-faq-qa.blogspot.com/
Post a Comment