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?
Correct Answer: A,C
A . 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 Scan12. . You query v$SYSTAT and filter for the statistic 'cell 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 session12. https://www.databasejournal.com/oracle/monitoring-smart-scans-in-oracle-exadata/
1z1-902 Exam Question 57
What are two recommended configuration best practices for backup and recovery on Exadata?
Correct Answer: A,D
1z1-902 Exam Question 58
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category. Which two monitoring tools might be useful in examining I/O performance for the prod database?
Correct Answer: C,D
According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are: cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the storage layer. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us . These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.
1z1-902 Exam Question 59
Examine this list of software components: 1. Oracle KVM Guest 2. Oracle Enterprise Manager Agent (OMA) 3. ASM instance 4. RDBMS instance 5. Automatic Diagnostic Repository Command Interpreter (ADRCI) 6. CELLCLI 7. Cell Server(CELLSRV) 8. diskmon 9. Restart Server (RS) 10. Management Server (MS) What is the correct location where these software components can run in the standard Exadata Database Machine deployment?
Correct Answer: E
Oracle KVM Guest, Oracle Enterprise Manager Agent (OMA), RDBMS instance, Automatic Diagnostic Repository Command Interpreter (ADRCI), CELLCLI, diskmon, and Restart Server (RS) can all run on the database servers. The Cell Server (CELLSRV) and Management Server (MS) can both run on the Exadata storage servers. Specific instructions for installing and configuring these software components can be found in the book and can be referenced here: https://docs.oracle.com/cd/E80920_01/E80920/html/x9m_software_components.html.
1z1-902 Exam Question 60
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?