Re: trace to find time spent in memory sorts
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 23 Feb 2012 08:56:39 +0000
Message-ID: <CABe10sbuRf9on7teBrg7+BV4FTc=Zryxy12hQ-u9o4jfs7HoEA_at_mail.gmail.com>
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_at_banfield.net> 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.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
Date: Thu, 23 Feb 2012 08:56:39 +0000
Message-ID: <CABe10sbuRf9on7teBrg7+BV4FTc=Zryxy12hQ-u9o4jfs7HoEA_at_mail.gmail.com>
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_at_banfield.net> 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.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 23 2012 - 02:56:39 CST