Multiple choice technology databases

Which view helps in identifying resource utilization of queries?

  1. V$SQL
  2. V$SQL_STAT
  3. V$SQLSTATS
  4. V$SQL_STATISTICS
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

V$SQLSTATS is the Oracle view that provides resource utilization metrics for SQL queries, including CPU time, buffer gets, and disk reads. V$SQL provides query text and execution statistics but not detailed resource metrics, while the other two views don't exist.

Keep practicing — related questions