Do we need any outline_parameters in Oracle 10g for its performance ? Please let me know if anybody knows the answer to this. Thank you.
user_stored_outlines and create_stored_outlines parameters are needed to control outline behaviour.
You can find the article related to this at http://www.ardentperf.com/2007/03/23/tuning-sql-statement-execution-in-10g-part-2/
No one has followed this question yet.