118. You detected a sudden file I/O load on your database. Consequently, you need to isolate user sessions that are contributing to the load. What is the first diagnostic step that you can take in the given scenario?
A.query the V$SYSSTAT dynamic performance view to identify the SQL statements causing maximum I/O
B.use Top Session diagnostic pack in Oracle Enterprise Manager to identify the sessions that are contributing most to the I/O
C.use the findings of the Reorg Wizard to identify the SQL statements that are causing maximum I/O
D.query the V$SESSION dynamic performance view to check the value for the ROW_WAIT_ROW# column
ANSWER: B
119. The database performance is degrading. You need to isolate the SQL statements that are contributing to the disk I/O load. Which diagnostic step would you recommend in the given scenario?
A.querying the V$SYSSTAT dynamic performance view to identify the SQL statements causing maximum I/O
B.query the V$SQL dynamic performance view to check the value for the EXECUTIONS column
C.using the findings of the Reorg Wizard to identify the SQL statements that are causing maximum I/O
D.using Oracle SQL Analyze application of the Oracle Tuning pack to identify the SQL statements that consume the most resources
ANSWER: D
100% Guarantee to Pass Your 1z0-033 exam and get your 9i DBA Certification
Powered By