Re: Tuning tool

On Jun 30, 1: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.

If you are using the dbconsole and have the appropriate licenses, you can grab it there. There are a bunch of other options, most of which require reading the manuals. The SQL tuning overview chapter in the performance tuning guide is a good start. There is a faq: http://www.orafaq.com/wiki/Performance_Tuning There are very good examples on asktom.oracle.com.

See http://www.dbaoracle.net/readme-cdos.htm for some other suggestions.

jg

--
@home.com is bogus.
“The United States faces a threat from al-Qaeda today that is
comparable to what it faced on Sept. 11, 2001.” - Seth Jones