Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: quote a few reasons to downgrade a database release

RE: quote a few reasons to downgrade a database release

From: <oracle-l-bounce_at_freelists.org>
Date: Mon, 1 May 2006 11:28:05 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD06FE906@ex2.ms.polyserve.com>


>>>01060412210634 17-APR-06
>>> 26.978 121 COGLINE 100
>>>
>>>Obviously the rule hint does still work.

How does that prove the rule hint worked? This is a new 10gR2 hint that I just tested:

$ sqlplus rw/rw

SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 1 13:31:15 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> select /*+ bogus_hint */ count(*) from product ;

  COUNT(*)


   1215903

SQL>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 01 2006 - 13:28:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US