Re: Tuning tool
From: GuangMei <zlmei_at_hotmail.com>
Date: Mon, 30 Jun 2008 14:20:50 -0700 (PDT)
Message-ID: <a69bc517-e267-4de1-9bcc-d2d3efee107c@j22g2000hsf.googlegroups.com>
Date: Mon, 30 Jun 2008 14:20:50 -0700 (PDT)
Message-ID: <a69bc517-e267-4de1-9bcc-d2d3efee107c@j22g2000hsf.googlegroups.com>
On Jun 30, 4:13 pm, Luting <houlut..._at_gmail.com> wrote:
> Hi all,
>
> I am using 10g. I want to test a few queries and have a look at the
> execution plan. But I cannot find where is the tool. The tuning tool
> seems only applicable to the most used queries in the database, but
> not any one.
Try to log into sqlplus, and issue SET AUTOTARCE ON, then run your query and you should see the explain plan.
Hope this helps.
Guang
Received on Mon Jun 30 2008 - 16:20:50 CDT