Oracle
1Z0-054 · Question #66
1Z0-054 Question #66: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #66. The question stem and answer options stay visible for context.
Question
You work for a company as a DBA. The company has an application to manage the details of its business and customer base. However, application users complain that updating the SALES record takes more time than it used to earlier. On investigation, you notice that the application performance degrades when a call is made to the UPDATE_INV procedure. Further, you execute the following query to investigate: SQL> SELECT name, type, sharable_mem, kept 2 FROM v$db_object_cache 3 WHERE sharable_mem > 4000 4 AND EXECUTIONS > 5 5 AND (type='FUNCTION' OR type='PROCEDURE') 6 / NAME TYPE SHARABLE_MEM KEPT ------------------- -------------- --------------- ----------- GETEMKEY FUNCTION 13695 YES UPDATE_INV PROCEDURE 14766 NO SETEMUSERCONTEXT PROCEDURE 13703 YES DECRYPT FUNCTION 17790 YES UPDATE_DEPT PROCEDURE 18765 NO What would you do to improve the performance?
Options
- AEnable the result cache if not already enabled.
- BFlush the shared pool to make space for this procedure.
- CKeep the UPDATE_INV procedure by using the DBMS_SHARED_POOL.KEEP procedure.
- DIncrease the size of the keep buffer pool to accommodate the UPDATE_INV procedure.
- EAsk the developers to modify and use literals instead of bind variables in the UPDATE_INV
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.