toracleoutput hint

[Anonymous]

HI please provide an example for using advance settings like hint and other options in toracleoutput

[Anonymous · Accepted solution]

Hi,

     Hints are tuning tools of past and Oracle database is intelligent enough to identify the best performance route by itself.

     So if you are trying to force Hints to Oracle, it may in turn degrade the performance of Oracle DB.

     Please also refer the link below from Oracle AskTom site for details.

https://asktom.oracle.com/pls/asktom/f?p=100:11:0:::11_QUESTION_ID:7038986332061

      If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi