What are things you do to reduce patch timing ?

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

(Continued from previous question...)

What are things you do to reduce patch timing ?

You can take advantage of following -
# Merging patches via admrgpch
# Use various adpatch options like nocompiledb or nocompilejsp
# Use defaults file
# Staged APPL_TOP during upgrades
# Increase batch size (Might result into negative )

(Continued on next question...)

Other Job Interview Questions

• What is a cursor for loop?
• What are between database triggers and form triggers?
• What should be the return type for a cursor variable. Can we use a scalar data type as return type?
• How many ORACLE HOME are Oracle Applications and whats significance of each ?
• What is RRA/FNDFS ?
• If APPS_MRC schema is not used in 11.5.10 and higher then How MRC is working ?
• What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
• Can you clone from multi node system to single node system and vice versa ?
• What is difference between Rename and Alias?
• What are different modes of parameters used in functions and procedures?
• More...