Re: Oracle WTF candidate
From: dombrooks <dombrooks_at_hotmail.com>
Date: Wed, 26 Sep 2012 14:03:49 -0700 (PDT)
Message-ID: <80f2b515-49f3-4cb3-991b-fe20dab39f36_at_googlegroups.com>
Maybe we're reading different articles or maybe different browsers display it differently (or rss readers?) ...
Date: Wed, 26 Sep 2012 14:03:49 -0700 (PDT)
Message-ID: <80f2b515-49f3-4cb3-991b-fe20dab39f36_at_googlegroups.com>
Maybe we're reading different articles or maybe different browsers display it differently (or rss readers?) ...
He says:
- Copy your SQL into a file (let’s call it slow_query.sql)
- run the wrapping script as shown below
The wrapping script which does amongst other things:
- alter session set statistics_level = all;
- _at_slow_query.sql;
