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.)

Question

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.)

Accepted Answer

C. Usage of CACHE and NOCACHE hints affects statistics for table scans (long tables) and table D. redo log space requests indicates the number of times a there were waits for disk space to be

Answer

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

Answer

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

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…

Question

Exhibit

Options

How the community answered

Community Discussion