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
Messages: 10
Registered: February 2010
Location: chennai
Junior Member

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: 65137
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

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

Current Time: Thu Aug 17 04:54:50 CDT 2017

Total time taken to generate the page: 0.16099 seconds