max function

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 number | | Expresssion | Expression that gives a number | | Expresssion | Optional expression that gives a number | | Expresssion | Optional expression that gives a number | | … | … |
p=. ← avg function / min function →