When looking at v$sysstat you see that sorts (di

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

(Continued from previous question...)

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -How do you correct it?

Level: Intermediate
Expected answer: If you get excessive disk sorts this is bad. This indicates you need to tune the sort area parameters in the initialization files. The major sort are parameter is the SORT_AREA_SIZe parameter.

(Continued on next question...)

Other Job Interview Questions

• What is new_form built-in?
• Auditing
• What are the two types of views available in the object navigator (specific to report 2.5)?
• What are the database administrators utilities available?
• What is forms_DDL?
• What is a DBA?
• Do user parameters appear in the data modal editor in 2.5?
• What are the type of Synonyms?
• Audit Trial
• What are the dictionary tables used to monitor a database spaces?
• More...