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
    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

    View Answer

    Workspace

    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