Database - RAC/Scalability (MOSC)

MOSC Banner

what should we consider for memory forecasting /proc/meminfo versus free-m on linux?

edited Nov 26, 2014 10:01AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

Hello,

I have been struggling these days to find correct memory usage which we need to show in reports for trending and server RAM forecasting. The good thing in our environment is that we have all our databases configured in OEM 12c and all the required data is already available for us in MGMT$METRIC views. I am even able to figure out the metric combination that I can use for trending purpose the query of which is below:

select target_name, target_type, column_label,ROLLUP_TIMESTAMP, AVERAGE,MINIMUM,MAXIMUM from sysman.mgmt$metric_hourly

where metric_name = 'Load' and column_label = 'Memory Utilization (%)'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center