Oracle
1Z0-902 · Question #11
1Z0-902 Question #11: Real Exam Question with Answer & Explanation
The correct answer is A. YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes C. You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.. 1. YOU query VSSYSTEM_EVENTS and filter for the event cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan. 2. You query v$SYSTAT an
Question
You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform. Which two actions are NOT appropriate for that purpose?
Options
- AYOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes
- BYou query v$segment_statistics and filter for the Object ID of your table from dba_objects and the
- CYou query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.
- DYou run the CellCli-command list activerequest , filtering for the attributes ioReason and
Explanation
- YOU query VSSYSTEM_EVENTS and filter for the event
cell physical IO interconnect bytes returned by smart scan', associated to your table. This does not show how much data was filtered by Smart Scan, but only how much data was returned after Smart Scan. 2. You query v$SYSTAT and filter for the statisticcell smart table scan', associated to your table. This does not show how much data was filtered by Smart Scan for a specific table, but only for all tables in a session.
Community Discussion
No community discussion yet for this question.