Oracle
1Z0-054 · Question #157
View the Exhibit and examine the partial output from the following query in an online transaction processing (OLTP) database: SQL>SELECT intsize_csec,metric_name,value, metric_unit FROM v$sysmetric…
The correct answer is B. Very few executions of SQL statements resulted in reparsing. D. The database spends more time in wait events in comparison to statement processing. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the partial output from the following query in an online transaction processing (OLTP) database:
SQL>SELECT intsize_csec,metric_name,value, metric_unit FROM v$sysmetric; Which two conclusions can you draw about the database from these metrics? (Choose two.)
Exhibit
Options
- AThe buffer cache is inadequately sized for the workload.
- BVery few executions of SQL statements resulted in reparsing.
- CThere were no multipass executions in the Program Global Area (PGA).
- DThe database spends more time in wait events in comparison to statement processing.
How the community answered
(60 responses)- A13% (8)
- B80% (48)
- C7% (4)
Community Discussion
No community discussion yet for this question.