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>
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.orgReceived on Mon Jun 30 2008 - 18:57:33 CDT