Home » RDBMS Server » Performance Tuning » Autotrace (merged by CM) (Oracle 9.2, Windows)
Autotrace (merged by CM) [message #445677] Wed, 03 March 2010 05:59 Go to next message
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?
Re: Autotrace [message #445680 is a reply to message #445677] Wed, 03 March 2010 06:08 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Can this query be improved for performance?
Next Topic: Resource busy during stats gather
Goto Forum:
  


Current Time: Sat Dec 03 08:16:34 CST 2016

Total time taken to generate the page: 0.06825 seconds