What can cause a high value for recursive calls?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What can cause a high value for recursive calls? How can this be fixed?

Level: High
Expected answer: A high value for recursive calls is cause by improper cursor usage, excessive dynamic space management actions, and or excessive statement re-parses. You need to determine the cause and correct it By either relinking applications to hold cursors, use proper space management techniques (proper storage and sizing) or ensure repeat queries are placed in packages for proper reuse.

(Continued on next question...)

Other Job Interview Questions

• Database Links
• What is a deadlock and Explain?
• How can you find out how many users are currently logged into the database? How can you find their operating system id?
• Explain the read, write, and execute permissions on a UNIX directory.
• Describe what redo logs are.
• What is the use of place holder column?
• How can you enable automatic archiving?
• What are the built_ins used the display the LOV?
• Is it possible to disable the parameter from while running the report?
• Audit Trial
• More...