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!

Kernel para and sga,pga sizing

883994Sep 6 2011 — edited Sep 13 2011
Hello,

OS-HP-UX(configured to use high sga /no restrictions)

Current database is running without any issue
Due to increase in physical ram i plan to increase sga and pga(ram is increase about 3 times)
My question:
1)should i also increase sga and pga in same propotion (3 times then existing)
or use 70% ROT formula

2)whatever figure i arrive by analysis for increasing sga,do i need to change kernel parameters also
(does i requre to change kernel parameter every time ram and sga is increased)

Please suggest

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2011
Added on Sep 6 2011
#general-database-discussions
19 comments
743 views