RE: [suse-oracle] Cost in Plan Table

From: Paul Gilligan (pdgilligan@oyap.net)
Date: Fri Oct 04 2002 - 14:12:27 CEST

  • Next message: Maurice Kemmann: "[suse-oracle] OT" 
    From: "Paul Gilligan" <pdgilligan@oyap.net>
date:  Fri, 04 Oct 2002 12:12:27 -0000
Message-Id: <20021004121227.ADDA0C222@om1.oyap.net>
Subject: RE: [suse-oracle] Cost in Plan Table

    Caution dont use DBMS_STATS with 8.1.7.0.0, serious bug issues.

    > If the optimizer is CHOOSE you must have the optimizer statistics to
    > enable the CBO. Did you gather the statistics via ANALYZE or DBMS_STATS?
    >
    > > -----Original Message-----
    > > From: Rajiv Khatri [mailto:rajiv.khatri@patni.com]
    > > Sent: 04 October 2002 14:20
    > > To: Christian Antognini; 'suse oracle list'
    > > Subject: RE: [suse-oracle] Cost in Plan Table
    > >
    > > Hi Chris
    > >
    > > I have also checked the optimizer in both the situation it is Choose
    > only.
    > > Raj
    > >
    > > -----Original Message-----
    > > From: Christian Antognini [mailto:Christian.Antognini@trivadis.com]
    > > Sent: Friday, October 04, 2002 5:39 PM
    > > To: rajiv.khatri@patni.com; suse oracle list
    > > Subject: RE: [suse-oracle] Cost in Plan Table
    > >
    > >
    > > Hi Rajiv
    > >
    > > Probably without hint your query is optimized by the RBO. Therefore no
    > > cost is computed. Adding hints to a query allways "force" the CBO...
    > > except for the hint RULE ;-)
    > >
    > > Chris
    > >
    > > > -----Original Message-----
    > > > From: Rajiv Khatri [mailto:rajiv.khatri@patni.com]
    > > > Sent: 04 October 2002 14:08
    > > > To: 'suse oracle list'
    > > > Subject: [suse-oracle] Cost in Plan Table
    > > >
    > > > Hi
    > > >
    > > > When I run query with hint it shows me the cost = 4 in plan table.
    > > > But when i run the same query without hint the cost is NULL in the
    > > plan
    > > > table.
    > > >
    > > > I want to see the cost for the query without hint. How to do ?
    > > >
    > > > Oracle 8i. (8.1.7)
    > > > NT 4.0
    > > >
    > > > Rajiv
    > > >
    > > >
    > > >
    > > >
    > > >
    > ---------------------------------------------------------------------
    > > > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    > > > For additional commands, e-mail: suse-oracle-help@suse.com
    > > > Please see http://www.suse.com/oracle/ before posting
    > >
    > >
    > > ---------------------------------------------------------------------
    > > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    > > For additional commands, e-mail: suse-oracle-help@suse.com
    > > Please see http://www.suse.com/oracle/ before posting
    >
    > ---------------------------------------------------------------------
    > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    > For additional commands, e-mail: suse-oracle-help@suse.com
    > Please see http://www.suse.com/oracle/ before posting
    >
    > 

    -- 
Paul Gilligan
Oracle RDBMS Consultant
Oracle on SuSE Linux Consultant
mobile : +44(0) 771 347 1599

    ---------------------------------------------------------------------
To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
For additional commands, e-mail: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting

    This archive was generated by hypermail 2.1.4 : Fri Oct 04 2002 - 14:32:54 CEST