Hi,
I need to increase the SGA on the database which is currently at 100MB. I need to make it 150MB.
What are the parameters to change in the init.ora file. Oracle v 8
Printable View
Hi,
I need to increase the SGA on the database which is currently at 100MB. I need to make it 150MB.
What are the parameters to change in the init.ora file. Oracle v 8
SGA Primarily made up of db_block buffers, shared pool and log buffer. Modify parameters appropriate to your environment requirement or current memory issues.
I'm not sure abot 8, 8i the SGA is made up of the following
(db_block_buffers * db_block_size)+ shared_pool_size + log_buffers + large_pool_size + java_pool_size
Increasing the db_block_buffers would enhance the reads
similarly increasing the shared pool size would increase the query performance, large_pool is normally used when there arent enough space in the shared pool to do a single fetch
I hope this would clear your doubts
Sam
Thanks sambavan and sreddy