1Z0-054 · Question #15
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…
The correct answer is D. The tkprof output file for the trace generated would not display bind variable values if bind. See the full explanation below for the reasoning.
Question
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?
Options
- AThe tkprof output file for the trace generated would display only the timed statistics for the SQL
- BThe tkprof output file for the trace generated would display statistics for all the sessions created
- CThe tkprof output file for the trace generated would display bind variable values if bind variables
- DThe tkprof output file for the trace generated would not display bind variable values if bind
How the community answered
(64 responses)- A3% (2)
- B6% (4)
- C13% (8)
- D78% (50)
Community Discussion
No community discussion yet for this question.