Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Buffer Cache too big?

K-Dec 19 2011 — edited Dec 20 2011
Hello Oracle community!

I'm having issues because of my current SGA size on a Win 32-bit platform, its measures are normally on 6,811,549,696 bytes. There was another database administrator before me but he left the company, his instructions were that he setup this size because that time RAM memory was not the problem.
The OS' parameters are set to read the entire 8GB RAM.

If I set a SGA_TARGET to around 6GB, will I only have -800mb on my db and no problems at all? Is there any way to check things better than just set a SGA_TARGET and pray?

Thank you very much!
This post has been answered by Aman.... on Dec 20 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2012
Added on Dec 19 2011
#general-database-discussions, #performance, #windows
26 comments
758 views