Hi All,
We are using Exadata 1/8th Rack which is having 256 GB memory and 12 cores on each Database server.
Our requirement is to create 15 databases out of which 10 are standalone and 5 are clustered database.
Now we are concerned about how the memory and cpu will be done for all these databases. I know we should not allocate more than 75% of total memory and cpu on the server. But don't know how much sga and pga I should allocate to each db and what is the mathematics here.
Kindly let us know if any one has done same kind of configuration earlier or any best practices to resolve such issues.
Also, please suggest if instance caging will be helpful here, please share detail if anyone has experience instance caging on exadata.
Your assistance is highly appreciated.
Thanks,
Vineet