Tuning tool
in [Oracle]
|
From: Luting on 30 Jun 2008 16:13 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.
From: Mladen Gogala on 30 Jun 2008 16:44 On Mon, 30 Jun 2008 13:13:22 -0700, 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. The tool is here: http://www.homedepot.com No matter what tool you need, yup, they have it. -- http://mgogala.freehostia.com
From: Rick Rankin on 30 Jun 2008 17:05 On Jun 30, 3:44 pm, Mladen Gogala <mgog...(a)yahoo.com> wrote: > On Mon, 30 Jun 2008 13:13:22 -0700, 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. > > The tool is here:http://www.homedepot.com > No matter what tool you need, yup, they have it. > > --http://mgogala.freehostia.com You're a regular saint
From: GuangMei on 30 Jun 2008 17:20 On Jun 30, 4:13 pm, Luting <houlut...(a)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
From: joel garry on 30 Jun 2008 18:09
On Jun 30, 1:13 pm, Luting <houlut...(a)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 |