nerdexam
Oracle

1Z0-417 · Question #74

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

The correct answer is B. ASH provides detailed session level data, SQL Trace/TKPROF does not. See the full explanation below for the reasoning.

Question

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

Options

  • AASH provides time based data, SQL Trace/TKPROF does not
  • BASH provides detailed session level data, SQL Trace/TKPROF does not
  • CASH is always on, SQL Trace/TKPROF is not
  • DASH identifies Bind variables that are available, SQL Trace/TKPROF does not
  • EASH counts and has occurrence data, SQL Trace/TKPROF does not

How the community answered

(32 responses)
  • A
    16% (5)
  • B
    72% (23)
  • C
    6% (2)
  • D
    3% (1)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-417 Practice