Which metric should be used to set the appropriate threshold?

View the Exhibit.

Examine the query on the v$servicemetric view and the output.You wish to
define a service-level threshold based on wall-clock time to monitor the performance of the
service.
Which metric should be used to set the appropriate threshold?

View the Exhibit.

Examine the query on the v$servicemetric view and the output.You wish to
define a service-level threshold based on wall-clock time to monitor the performance of the
service.
Which metric should be used to set the appropriate threshold?

A.
DELTA

B.
CPUPERCALL

C.
CALLSPERSEC

D.
DBTIMEPERSEC

E.
DBTIMEPERCALL



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Rodrigo

Rodrigo

http://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3010.htm

V$SERVICEMETRIC

Displays metric values measured on the most recent time interval period for services executing inside the database.
Service metrics are measured in 5-second and 1-minute intervals.

DELTA
Indicates the predicted increase in the goodness for every additional session that is routed to this instance

CPUPERCALL
CPU time per call (in microseconds)

CALLSPERSEC
Number of user calls per second

DBTIMEPERSEC
Database time per second

DBTIMEPERCALL
Elapsed time per call (in microseconds)

L. Zhu

L. Zhu

wall-clock time to measure performance

E. DBTIMEPERCALL is the one