OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » autotrace (autotrace on) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

autotrace [message #274388]

Mon, 15 October 2007 22:41

ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai

Junior Member

Hi,
what are the step taken to put the autotrace trace active. and see the plan of the query.?

Report message to a moderator

Re: autotrace [message #274390 is a reply to message #274388]

Mon, 15 October 2007 22:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> set autotrace
Usage: SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]
SQL>

Report message to a moderator

Re: autotrace [message #274393 is a reply to message #274390]

Mon, 15 October 2007 22:54

ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai

Junior Member

no how to execute the explain plan there is some package which i have to use it. to run this utility again and again?

Report message to a moderator

Re: autotrace [message #274395 is a reply to message #274388]

Mon, 15 October 2007 23:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> ALTER SESSION SET SQL_TRACE=TRUE;
SQL> ...
SQL> EXIT

then run trace file through TKPROF utility

Report message to a moderator

Re: autotrace [message #274398 is a reply to message #274395]

Mon, 15 October 2007 23:07

ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai

Junior Member

Thanks..as one of my friend told me that first we have to run one package in our database and then grant it to every one.
that why i submitted this request...

Report message to a moderator

Re: autotrace [message #274404 is a reply to message #274388]

Mon, 15 October 2007 23:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Thanks..as one of my friend told me that first we have to run one package in our database and then grant it to every one.
>that why i submitted this request...
What does these 2 lines have to do with generating EXPLAIN PLANS?

You do NOT generate EXPLAIN PLANs for PL/SQL; only for SQL!

Report message to a moderator

Re: autotrace [message #274818 is a reply to message #274388]

Wed, 17 October 2007 05:10

rikfair
Messages: 22
Registered: October 2006
Location: UK

Junior Member

Hi, This article has details on using autotrace and explain plan, including the script you need to run to create the plan table.

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11170

Hope this helps.

Report message to a moderator

Previous Topic:	Regarding sort optimsation (merged)
Next Topic:	Running queries parallely

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 17 01:35:29 CST 2025