top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: What all important parameters of the init.ora ,....., increase the SGA size?

0 votes
292 views

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

posted Jan 23, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

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

answer Jan 27, 2015 by Arun Gowda
...