On Wed, 17 Jun 2020 at 09:14, Peter <[email protected]> wrote: > So I can't cap memory based on a oracle instance ? Like prioritising each > oracle instance ? >
You can to some extent. You define the maximum by SGA and PGA per instance, and things like connection pools. The actual usage varies somewhat by workload. But very few customers will make their guests large enough to hold all database instances at their maximum usage. That would leave a lot of excess memory that Linux will use for other things (like cache data). Instead, they share much of the white space and cross their fingers. If your databases have short burst of activity and long periods of idle, it might be more attractive to configure Linux guests to fit that instance and let z/VM take resources away when there is demand from others and the instance is idle. Rob ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www2.marist.edu/htbin/wlvindex?LINUX-390
