Which of these views would be used to diagnose tablespace performance problems?
A . V$FILE_IO
B. V$FILESTAT
C . V$TABLESPACE
D . V$TABLESPACE_USAGE
E . DBA_TABLESPACES
Explanation:
Answer B: The V$FILESTAT view contains accumulated data about the number of physical reads and writes, blocks read and written, and the total read and write time. These statistics can be used to determine hot spots, or disks that are much more active than others; , and to evaluate the average read and write time for the files in a tablespace. The information can then be used to determine if files need to be moved to different disk drives.
No comments:
Post a Comment