memory requirement in oracle database

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

memory requirement in oracle database

satish
This post was updated on .
Dear Erman,

We are about to procure a new server for 12c database with R12.2.5 erp application.we have users around 1500.
500 users will be concurrently connect at any point of time
we will install only 1 database in the server
we use different server for installing application

we request you to suggest some approximate values like how much memory and cpu can be used
How much SGA_TARGET and PGA_AGGREGATE_TARGET can we use

Thank you
Reply | Threaded
Open this post in threaded view
|

Re: memory requirement in oracle database

ErmanArslansOracleBlog
Administrator
you want me to do sizing..

Sizing is completely dependent on the environment. So it may vary accordingly.

Read this post -> https://ermanarslan.blogspot.com/2016/05/ebs-activepassive-cluster-dr-minimal.html

There is an example sizing there.. It may give you an idea..