Sam is a DBA of an OLTP system that has a large number of users. He receives a complaint from two users with client ids Richard and Hardy that the Application response time is poor. To understand the problem faced by Richard and Hardy better, Sam wants to gather the statistics for all active sessions of these clients for a particular instance.
Which two of these steps should Sam perform and in which order to view the relevant information?
A.
1, 3
B.
1, 4
C.
2, 3
D.
2, 4
Explanation:
The question asks for “to gather the statistics for all” and not to enable tracing. Thus it can be assumed that we need to do DBMS_MONITOR.CLIENT_ID_STAT_ENABLE (p18-10) and not DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE (p18-13)
CLIENT_ID_STAT_ENABLE Enable / Disable Statistics
gathering for a given Client
1. Statistics can be seen
Identifier
through
VSCLIENT_STATS
CLIENT_ID_STAT_DISABLE
LEEnable / Disable
1. Trace data may be
Tracing for a given Client
written
Identifier
to many trace files as the
CLIENT_ID_TRACE_ENAB
trace may effect multiple
connected
sessions with the