You are administering a database that supports multiple applications, which make dedicated
connections to the database instance by using different services. You execute the command
to enable tracing of theORCL1service:
Which two statements are true?(Choose two.)
A.
Asingle trace file is generated for all sessions mapped to theORCL1service.
B.
SQL trace is enabled for all modules and actions for sessions mapped to
theORCL1service.
C.
An SQL trace file is generated for each session that maps to theORCL1service.
D.
An SQL trace file is generated for each of the modules using theORCL1service.
E.
SQL trace is not enabled for the service because a module name is not specified.
A – wrong, a single file is generated for each session
B – right
C – right
D – wrong, not for each module, but only those which are in given service_name
E – wrong, a module name can be null.
B,C
Hi all, suppose you are working in RAC enviornment ( B is wrong), I think A and C are correct.
I’m I right
please check the following site
http://psoug.org/reference/dbms_monitor.html
Hi all, sorry I made mistake you are right.
BC