Re: Tuning tool

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 30 Jun 2008 16:57:33 -0700
Message-ID: <1214870242.668287@bubbleator.drizzle.com>


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

Explain Plan
http://www.psoug.org/reference/explain_plan.html

Autotrace
http://www.psoug.org/reference/autotrace.html

DBMS_PROFILER
http://www.psoug.org/reference/dbms_profiler.html

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jun 30 2008 - 18:57:33 CDT

Original text of this message