Re: Optimizer

From: <Jared.Still_at_radisys.com>
Date: Tue, 9 Mar 2004 15:07:17 -0800
Message-ID: <OF905E9177.6279A38B-ON88256E52.007EEB3B-88256E52.007EECD9@radisys.com>

Here is a test for anonymous pl/sql blocks only.

You will have to devise your own for stored procedures.

declare

v_mode varchar2(30);

begin

execute immediate 'alter session set optimizer_mode='

      || ''''
      || 'first_rows'
      || '''';

   select value into v_mode
   from v$parameter
   where name = 'optimizer_mode';

dbms_output.put_line(v_mode);

end;
/

I curious why you are asking this.

Sounds like another Oracle Urban Legend to me.

Jared

<Satheesh.Babu_at_iflexsolutions.com>
Sent by: oracle-l-bounce_at_freelists.org
03/08/2004 12:42 AM
Please respond to oracle-l

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        Optimizer_Mode

Is optimizer_mode inside pl/sql program will be always 'ALL_ROWS' irrespective of what has been set in instance or session level?

Thanks and Regards,
Satheesh Babu.S
Bangalore

DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is

required please request a hard-copy version.


----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Mar 09 2004 - 17:04:24 CST

Re: Optimizer_Mode