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!

ALTER SESSION SET OPTIMIZER_MODE

Tricampeon_1981Dec 2 2019 — edited Dec 2 2019

Hello friends, ask a question,

I am reviewing a pakages which, within each sql query, change the mode of op´timziar to:

I would like to know what does the basic idea do, I need to improve the performance of these sql query and I would like to know if that change works for me or not

EXECUTE IMMEDIATE 'ALTER SESSION SET OPTIMIZER_MODE = CHOOSE';

I would like to know what does the basic idea do, I need to improve the performance of these sql query and I would like to know if that change works for me or not

version

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

"CORE 11.2.0.2.0 Production"

TNS for HPUX: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production

This post has been answered by L. Fernigrini on Dec 2 2019

Jump to Answer

Added on Dec 2 2019

3 comments

8,567 views