Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by…

Question

Options

• A1
• B2 and 4
• C2 and 5
• D3 and 4
• E3 and 5

• A
  2% (1)
• B
  93% (41)
• E
  5% (2)

Explanation

Tracing information is present in multiple trace files and you must use the trcsess tool to collect it into a single file. Not 1: Parameter service_name Name of the service for which tracing is enabled. Name of the MODULE. An optional additional qualifier for the service. * The procedure enables a trace for a given combination of Service, MODULE and ACTION name. The specification is strictly hierarchical: Service Name or Service Name/MODULE, or Service Name, MODULE, and ACTION name must be specified. Omitting a qualifier behaves like a wild- card, so that not specifying an ACTION means all ACTIONs. Using the ALL_ACTIONS constant achieves the same purpose. * SERV_MOD_ACT_TRACE_ENABLE Procedure This procedure will enable 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);

No community discussion yet for this question.