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 Identifier 1. Statistics can be seen CLIENT_ID_STAT_DISABLE
Enable / Disable Tracing 1. Trace data may be for a given Client written sessions with the CLIENT_ID_TRACE_ENABLE Identifier