RE: too low optimizer_index_cost_adj causing bizarre index choice

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Fri, 10 May 2002 08:43:31 -0800
Message-ID: <F001.0045E580.20020510084331@fatcity.com>

Where've you been? According to Oracle, customers haven't needed a DBA since version 7.

-----Original Message-----
Sent: Friday, May 10, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L choice

ROFL over here over this one. Wish I could have been there.

I hear that in 9i you won't need a DBA anymore!

jack

• "Miller, Jay" <JayMiller_at_TDWaterhouse.com> wrote:
  > Is this surprising? I still remember an Oracle
  > presentation when 8i was
  > first coming out and the Oracle rep answered a
  > question about hints by
  > saying that no one should use hints any more because
  > the optimizer always
  > used the best path.
  >
  > Half the room burst out laughing :).
  >
  > Jay Miller
  >
  > -----Original Message-----
  > Sent: Thursday, May 09, 2002 11:43 PM
  > To: Multiple recipients of list ORACLE-L
  > choice
  >
  >
  > Even Oracle was reluctant
  > to admit that it was accessing a wacko index until I
  > pressed them for it. I asked them to give me the
  > relevant CBO code, but noooooo, not even a decent
  > 10053 doc.....
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Miller, Jay
  > INET: JayMiller_at_TDWaterhouse.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: jack_silvey_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: mvergara_at_guidant.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri May 10 2002 - 11:43:31 CDT