Re: trace to find time spent in memory sorts

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: Josh.Collier@xxxxxxxxxxxx
  • Date: Thu, 23 Feb 2012 08:56:39 +0000

It's been a while since I looked at the sort traces, but I *think* event
10032 will give that information, albeit possibly tangentially.
On Feb 23, 2012 2:13 AM, "Josh Collier" <Josh.Collier@xxxxxxxxxxxx> wrote:
> How can I find out how much time is spent by a query in memory sorts?  i
> can easily get i/o timings, but I have suspicion my query is spending all
> its time on sorts...
> 64 bit linux
> 11.2.0.2
> Thanks for your time,
>
> Josh C.
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


--
//www.freelists.org/webpage/oracle-l


Other related posts: