Re: autotrace

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 17 Jul 2006 18:17:01 +0200
Message-ID: <44bbb7fe$0$31659$626a54ce@news.free.fr>

"Gints Plivna" <gints.plivna_at_gmail.com> a écrit dans le message de news: 1153137348.573607.108590_at_m79g2000cwm.googlegroups.com...
| Prasath wrote:
| > I agree that there might be a slight overhead in collecting the
| > statisitcs of a query. But I am concerned with the amount of time
| > taken. There must be something wrong with the session. I am looking
| > for some clues.
|
| Oracle docs are your friend
| http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96533/autotrac.htm
|
| SET AUTOTRACE ON EXPLAIN
| The AUTOTRACE report shows only the optimizer execution path.
|
| Only plan, no actual execute of query, therefore such a difference.
|
| Gints Plivna
| http://www.gplivna.eu/
|

Wrong! There is no result output but the query is executed.

Regards
Michel Cadot Received on Mon Jul 17 2006 - 11:17:01 CDT