A new application module is deployed on middle tier and is connecting to your database. You want to monitor the performance of the SQL statements generated from the application. To accomplish this…

Question

Options

• A1, 2, 3, 4, 5
• B2, 3, 1, 4, 5
• C3, 1, 2, 4, 5
• D1, 2, 4, 5
• E1, 3, 4, 5
• F2, 1, 4, 5

• A
  76% (16)
• C
  14% (3)
• D
  5% (1)
• F
  5% (1)

Explanation

• Before tracing can be enabled, the environment must first be configured to enable gathering of * (gather statistics): DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE Enables statistic gathering for a given combination of Service Name, MODULE and ACTION * DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE Enables SQL tracing for a given combination of Service Name, MODULE and ACTION globally unless an instance_name is specified. dbms_monitor.serv_mod_act_trace_enable( service_name IN VARCHAR2, module_name IN VARCHAR2 DEFAULT ANY_MODULE, action_name IN VARCHAR2 DEFAULT ANY_ACTION, waits IN BOOLEAN DEFAULT TRUE, binds IN BOOLEAN DEFAULT FALSE, instance_name IN VARCHAR2 DEFAULT NULL, plan_stat IN VARCHAR2 DEFAULT NULL); SELECT instance_name FROM gv$instance; exec dbms_monitor.serv_mod_act_trace_enable('TESTSERV', dbms_monitor.all_modules, dbms_monitor.all_actions, TRUE, TRUE, 'orabase'); exec dbms_monitor.serv_mod_act_trace_disable('TESTSERV', dbms_monitor.all_modules, dbms_monitor.all_actions, 'orabase'); * When solving tuning problems, session traces are very useful and offer vital information. Traces are simple and straightforward for dedicated server sessions, but for shared server sessions, many processes are involved. The trace pertaining to the user session is scattered across different trace files belonging to different processes. This makes it difficult to get a complete picture of the life cycle of a session. Now there is a new tool, a command line utility called trcsess to help read the trace files. The trcsess command-line utility consolidates trace information from selected trace files, based on specified criteria. The criteria include session id, client id, service name, action name and module * Once the trace files have been consolidated (with trcsess), tkprof can be run against the consolidated trace file for reporting purposes.

No community discussion yet for this question.