|
-
Sga_target ?
I have a 4G memory windows server. I want to create an OLTP database on this machine. I have Oracle 10.2 installed. I want to use 2G of memory for this instance. Can someone please advise whether I should set the SGA_TARGET to 2G and have the server manage the buffer_pool and shared_pool? Can someone please advise whether this is good practice or should I manually set the memory parameters? I never used this parameter before and I am not sure what impact it might have on performance. Thank you.
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
|