A database supports three applications: CRM, ERP, and ACC. These applications connect to the database by using three different services: CRM_SRV for the CRM application, ERP_SRV for the ERP…

Question

Options

• AAll trace information for the service connection to inst1 will be stored in a single trace file.
• BA trace file is not created because the module name is not specified.
• CA single trace file is created for each session that uses the ACC_SRV service.
• DOnly those SQL statements that are identified with the ACC_SRV service executed on the inst1
• EAll trace information for the ACC_SRV service connected to inst1 is stored in multiple trace files,

• A
  4% (2)
• B
  2% (1)
• C
  71% (34)
• D
  8% (4)
• E
  15% (7)

Explanation

SERV_MOD_ACT_TRACE_ENABLE serv_mod_act_trace_enable and serv_mod_act_trace_disable, which enables and disables trace for given service_name, module and action. For example for a given service name you can trace all session started from SQLPlus. Module and action in your own created application can be set using dbms_application_info set_module and set_action procedures. serv_mod_act_trace_enable fills sys table wri$_tracing_enabled and view dba_enabled_traces on top of this table as follows: SQL> exec dbms_monitor.serv_mod_act_trace_enable(service_name=>'orcl', module_name=>'SQLPlus') PL/SQL procedure successfully completed. SQL> select * from sys.wri$_tracing_enabled; TRACE_TYPE PRIMARY_ID QUALIFIER_ID1 QUALIFIER_ID2 INSTANCE_NAME FLAGS ------ ---- ---------- ------------- ------------- ------------- ----- 4 orcl SQLPlus 8 SQL> select * from dba_enabled_traces; TRACE_TYPE PRIMARY_ID QUALIFIER_ID1 QUALIFIER_ID2 WAITS BINDS INSTANCE_NAME -------------- ---------- ------------- ------------- ----- ----- ------------- SERVICE_MODULE orcl SQLPlus TRUE FALSE

No community discussion yet for this question.