Re: Oracle WTF candidate

From: dombrooks <dombrooks_at_hotmail.com>
Date: Wed, 26 Sep 2012 13:26:22 -0700 (PDT)
Message-ID: <c1d3a00d-da30-43da-bcba-40aea3ed5d00_at_googlegroups.com>

I don't think that is very fair and I don't get what is the WTF.

Nikolay has some excellent advice on his blog and the quality of his replies on the OTN forums are consistently good.

All that he seems to be advising on this blog is that you wrap your slow SQL query in a sql script called slow_query.sql, and he has provided a wrapper of the various sql*plus commands to a) surpress the output of the query and to b) set statistics level to all and you will then get the excellent DBMS_XPLAN.DISPLAY_CURSOR output of the last executed query (hence the NULL sql id etc) with the all important actual execution statistics to compare against the estimates - the cornerstone of the cardinality feedback tuning methodology.

I see nothing WTF about this advice and in fact imagine it will be a good point of reference on the OTN forums for the stream of "my query is slow" threads.

If you think I have missed something, then please highlight the WTF.

Cheers,
Dominic Received on Wed Sep 26 2012 - 15:26:22 CDT