-
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.
Reddy,Sam
-
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
Thanx
Sam
Life is a journey, not a destination!
-
Thanks sambavan and sreddy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|