Oracle 1z0-040: Oracle Database 10g: New Features for Administrators
#101. 1. Execute DBMS_MONITOR.CLIENT_ID_STAT_ENABLE procedure for the two clients. 2. Execute DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE procedure for the two clients. 3. View the data in the V$CLIENT_STATS view. 4. View the data in the V$SERVICE_STATS view. 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?
gen. 0.066
Forum
Master braindump