Which dynamic performance view is the primary place to look for system performance and resource usage information?
A . V$RESOURCE
B . V$PERFORMANCE
C . V$SYSTEM_EVENT
D. V$SYSSTAT
E . V$SYSTEM_STATS
Explanation:
Answer D: System performance and resource usage stats are kept in the V$SYSSTAT view. Hit ratios, cumulative logons, total CPU usage, parse counts, total physical reads and writes, and in-memory and to-disk sorts are just a few of the vital statistics that are available in this view. Wait events are recorded in the V$SYSTEM_EVENT view; V$PERFORMANCE, V$RESOURCE, and V$SYSTEM_STATS are fictitious.
No comments:
Post a Comment