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!

Sga_target parameter change

User_PT6OPApr 6 2015 — edited Apr 6 2015

Dear All,

We have increased our server memory from 8G to 32G.

Now we would like to increase our sga_target parameter which is currently set as 4G

and pga_aggregate_target =1G.

we want to set sga_target to 60% of the memory.

what other parameters we need to consider before making this change like (/etc/sysctl.conf or etc)

os: rhel 6.5

db: 11.2.0.3.0 enterprise

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2015
Added on Apr 6 2015
#general-database-discussions
10 comments
2,755 views