question

OraLearner avatar image
OraLearner asked

Are outline_parameters needed in 10g ?

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.

oracleparameters
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
OracleApprender avatar image
OracleApprender answered

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/

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.