Re: [suse-oracle] Cost in Plan Table

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

  • Next message: Paul Gilligan: "RE: [suse-oracle] Cost in Plan Table" 
    From: "Paul Gilligan" <pdgilligan@oyap.net>
date:  Fri, 04 Oct 2002 12:06:47 -0000
Message-Id: <20021004120647.E07C9C222@om1.oyap.net>
Subject: Re: [suse-oracle] Cost in Plan Table

    What version are you using? there are many bugs in 8.1.7.0.0, which
    is the base version for 8i release 3.

    If you have a metalink account then you can always open a tar there :)

    ..... mainly becase you are NT (spit spit) but then again we have
    to be professional.

    I am sure you have read this but here is the link to 8i CBO info:

    http://download-uk.oracle.com/docs/cd/A87860_01/doc/index.htm

    Paul

    > 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
    >
    > 

    -- 
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:27:00 CEST