Home / CSE MCQs / Oracle Database MCQs :: Discussion

Discussion :: Oracle Database MCQs

  1. 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.
  2. A.
    Set the TRACE_ENABLED parameter to TRUE
    Set the threshold for the Current Logons Count metric
    Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE
    Set the SESSIONS_PER_USER limit in the profiles used by users

    View Answer


    Answer : Option B

    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.

Be The First To Comment