Multiple choice technology databases

How do you gather statistics in Oracle 10g

  1. AWR

  2. Statspack

  3. TKProf

  4. Utlb/Utle
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

AWR (Automatic Workload Repository) automatically collects performance statistics in Oracle 10g. Statspack is the older statistics collection tool, still available. TKProf is used to format and analyze SQL trace files, providing execution statistics. 'Utlb/Utle' in option D appears to be nonsensical or a typo.

Keep practicing — related questions