Which two interpretations are correct about the information obtained from this view?

View the Exhibit and examine the partial output obtained when you issued the following query:
SQL> SELECT name,class,value FROM v$sysstat ORDER BY class;
Which two interpretations are correct about the information obtained from this view? (Choose two.)
Exhibit:

View the Exhibit and examine the partial output obtained when you issued the following query:

SQL> SELECT name,class,value FROM v$sysstat ORDER BY class;

Which two interpretations are correct about the information obtained from this view? (Choose two.)

A.
db block changes indicates the number of data blocks that have been changed.

B.
buffer is pinned count indicates the number of buffers that are currently pinned in the database instance.

C.
Usage of CACHE and NOCACHE hints affects statistics for table scans (long tables) and table scans (short tables).

D.
redo log space requests indicates the number of times a there were waits for disk space to be allocated for the redo log entries.



Leave a Reply 1

Your email address will not be published. Required fields are marked *