SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

optimizer_features_enable=''9.2.0'''

baskar.lMar 12 2010 — edited Mar 13 2010

Hi all,

Good day..

DB version is 10.2.0.4 A pl/sql code was developed two year before for a concurrent program when the db was in 9.2.0.6 . The we migrated to 10.2.0.4 . Today i saw the code of the concurrent program which always takes 1+ hours to execute which calls a procedure where it was using 'EXECUTE IMMEDIATE 'ALTER session set optimizer_features_enable=''9.2.0''';'

Is that good to use that optimizer feature of 9i in 10.2.0.4??

thanks,
baskar.l

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2010

Added on Mar 12 2010

5 comments

1,436 views