Re: Optimizer Hints and Explain Plan
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Mon, 26 Oct 2009 15:04:14 -0700 (PDT)
Message-ID: <bf9250ce-cf48-4419-8b30-e21813d694c7_at_k19g2000yqc.googlegroups.com>
On Oct 22, 5:18 am, DeB <debashish.majum..._at_gmail.com> wrote:
> My apologies for the typo. It's /*+ NO_CPU_COSTING */.
> Yes, there seems to be no point in using this while generating the
> EXPLAIN PLAN.
> We intended to see the PLAN with only the I/O
> Thanks for your replies!
>
> --
> DeB
Date: Mon, 26 Oct 2009 15:04:14 -0700 (PDT)
Message-ID: <bf9250ce-cf48-4419-8b30-e21813d694c7_at_k19g2000yqc.googlegroups.com>
On Oct 22, 5:18 am, DeB <debashish.majum..._at_gmail.com> wrote:
> My apologies for the typo. It's /*+ NO_CPU_COSTING */.
> Yes, there seems to be no point in using this while generating the
> EXPLAIN PLAN.
> We intended to see the PLAN with only the I/O
> Thanks for your replies!
>
> --
> DeB
In >= 10.2.0 (and maybe 10.1.0, I don't recall), try...
select * from table(dbms_xplan.display_cursor(null, null, 'IOSTATS')); Received on Mon Oct 26 2009 - 17:04:14 CDT