9i 'optimizer_goal'

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 13 Nov 2001 14:54:25 +0000
Message-ID: <3BF13421.1A77@yahoo.com>

Can anyone confirm on a non-Win2K 9i platform?

SQL> alter session set optimizer_mode = first_rows_1;

Session altered.

SQL> alter session set optimizer_goal = first_rows_1; alter session set optimizer_goal = first_rows_1

                                   *

ERROR at line 1:
ORA-01986: invalid option for OPTIMIZER_GOAL

Yet - from the doco -

"The OPTIMIZER_GOAL parameter can have the same values as the
OPTIMIZER_MODE initialization parameter"

Cheers
Connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk



"Some days you're the pigeon, some days you're the statue..."

Received on Tue Nov 13 2001 - 08:54:25 CST