34. You create a stored outline and apply it for use. What strategy would you adopt to verify that the stored outline is being used for a statement?
A.verify OL$,OL$HINTS, and OL$NODES tables after running the statement with USE_STORED_OUTLINES set
B.examine the V$SQL dynamic performance view after running the statement with the USE_STORED_OUTLINES set
C.compare the explain plan output for the statement when running with and without the USE_STORED_OUTLINES set
D.compare the statspack output by taking snaps before and after running the statement with the USE_STORED_OUTLINES set
ANSWER: C
35. You are running low on a system resource, such as read/write throughput or CPU cycle. Which technique would you adopt to detect the most resource-consuming statements in your application code for a specific session?
A.use the contents of the alert log file
B.use the report generated by UTLBSTAT/UTLESTAT
C.take a trace and use TKPROF to see the formatted output
D.use the STATSPACK output generated with snapshot level 0
ANSWER: C
100% Guarantee to Pass Your 1z0-033 exam and get your 9i DBA Certification
Powered By