Skip to Main Content

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!

Formula to calculate SGA for 12c database OLTP

ivwviJan 23 2016 — edited Jan 25 2016

Dear Experts,

What is the formula to calculate SGA for an application database OLTP.

This surely will be dependent on many variables  like

1) Maximum number of connections application would have

2) database growth

  • connected users
  • server connections
  • total connections
  • connection memory
  • os/application memory
This post has been answered by JohnWatson2 on Jan 24 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2016
Added on Jan 23 2016
12 comments
2,812 views