Question

You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.

(a) Set the TRACE_ENABLED parameter to TRUE

(b) Set the threshold for the Current Logons Count metric

(c) Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE

(d) Set the SESSIONS_PER_USER limit in the profiles used by users

This question was addressed to me in quiz.

My query is from Installing Oracle Database 11g and Creating a Database topic in portion Oracle Database 11g Architecture Options of Oracle

Answer 1

Right choice is (b) Set the threshold for the Current Logons Count metric

Explanation: A metric is defined as the rate of change in some cumulative statistic. This rate can be measured against a variety of units, including time, transactions, or database calls. For example, the number database calls per second is a metric.