Hi all,
I am facing high cpu load averages on the oracle DBaaS node. Generally our DB load averages are around 3 but now it is 6+.
I am seeking expert guidance on calculating load on a database and determining what constitutes normal load levels for a specific database.
Could you share your insights on how to assess database load and what benchmarks or metrics we need to consider when evaluating if the load is within an acceptable range or reaching a high load state.
Any pratical tips or methodologies needed to follow while fixing baseline load average of a database and thresholds for high load situations would be greatly appreciated.
Are there any hard and fast rules to fix this much load is high for a database.
Kindly ignore any errors in construction of my question as I am not in to performance tuning and trying to learn about performance tuing as a DBA.