OraFAQ Forum: Performance Tuning » Autotrace (merged by CM)

Home » RDBMS Server » Performance Tuning » Autotrace (merged by CM) (Oracle 9.2, Windows)

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

Autotrace (merged by CM) [message #445677]

Wed, 03 March 2010 05:59

visuorac
Messages: 10
Registered: February 2010
Location: chennai

Junior Member

Hi,

What is the functionality of auto trace in oracle? how it will help to optimize the query?

Report message to a moderator

Re: Autotrace [message #445680 is a reply to message #445677]

Wed, 03 March 2010 06:08

Alessandro Rossi
Messages: 166
Registered: September 2008
Location: Rome

Senior Member

It acquires a sense only once you understand what it says.

When that day will come, it wouldn't be hard to know how it could help to identify performance problems.

Bye Alessandro

[Updated on: Wed, 03 March 2010 06:09]

Report message to a moderator

Re: Autotrace (merged by CM) [message #445692 is a reply to message #445677]

Wed, 03 March 2010 06:43

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL*Plus® User's Guide and Reference

Chapter 8 Tuning SQL*Plus
Section Tracing Statements
Paragraph Controlling the Autotrace Report

Chapter 12 SQL*Plus Command Reference
Section SET System Variable Summary
Paragraph SET AUTOT[RACE] {ON | OFF | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]

Regards
Michel

Report message to a moderator

Previous Topic:	Can this query be improved for performance?
Next Topic:	Resource busy during stats gather

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 09 19:19:12 CST 2026