Examine the values for the following initialization parameters:
STATISTICS_LEVEL = TYPICAL
TIMED_STATISTICS = true
You are managing an online transaction processing (OLTP) system. Application users notice that some queries have poor response time. You determine that queries from session ID 27, serial number 60, for user OE are heavy-resource consumers. To investigate further, you enabled tracing for the session by executing the following command:
SQL> EXECUTE dbms_system.set_sql_trace_in_session (27, 60, true);
Which statement is true?
A.
The tkprof output file for the trace generated would display only the timed statistics for the SQL statements.
B.
The tkprof output file for the trace generated would display statistics for all the sessions created by the user OE.
C.
The tkprof output file for the trace generated would display bind variable values if bind variables are used in the queries executed in the session.
D.
The tkprof output file for the trace generated would not display bind variable values if bind variables are used in the queries executed in the session.