Description
Finds the max value from a set, or from a number of values.
Example
Find the max number of sessions for all your oracle instances
max(instance[databasetype = 'oracle']/total_session_count)Returns the largest of the arguments (average session_count or 10)
max(avg(instance[databasetype = 'oracle']/total_session_count), 10)Syntax
max(expression)
max(expression1, expression2, ..)
Parameters
| Type | Description |
|---|---|
| Expresssion | Expression that gives a set of numbers |
| Type | Description |
|---|---|
| Expresssion | Expression that gives a number |
| Expresssion | Expression that gives a number |
| Expresssion | Optional expression that gives a number |
| Expresssion | Optional expression that gives a number |
| … | … |