Which is a true statement about the difference in the f…

Which is a true statement about the difference in the functionality of Active Session History (ASH) and SQL Trace/TKPROF?

Which is a true statement about the difference in the functionality of Active Session History (ASH) and SQL Trace/TKPROF?

A.
ASH provides time based data, SQL Trace/TKPROF does not

B.
ASH provides detailed session level data, SQL Trace/TKPROF does not

C.
ASH is always on, SQL Trace/TKPROF is not

D.
ASH identifies Bind variables that are available, SQL Trace/TKPROF does not

E.
ASH counts and has occurrence data, SQL Trace/TKPROF does not

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

Eric

Eric

C

Reply

Eini

Eini

Not C. If control_management_pack_access parameter is NONE, ASH is off.

B) The data present in ASH can be rolled up on various dimensions that it captures, including the following:
Session identifier and session serial number
Module and action name
Client identifier of the session
Service hash identifier
Consumer group identifier

https://docs.oracle.com/database/121/DBLIC/options.htm#DBLIC165

Reply

Orcl

Orcl

C is the correct answer

Reply