trace to find time spent in memory sorts

From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 23 Feb 2012 02:11:28 +0000

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

Follow-Ups:
- Re: trace to find time spent in memory sorts
  - From: Lei Zeng
- Re: trace to find time spent in memory sorts
  - From: Martin Berger
- Re: trace to find time spent in memory sorts
  - From: Niall Litchfield
- RE: trace to find time spent in memory sorts
  - From: TJ Kiernan

Other related posts:

» trace to find time spent in memory sorts - Josh Collier
» Re: trace to find time spent in memory sorts- Lei Zeng
» Re: trace to find time spent in memory sorts- Martin Berger
» Re: trace to find time spent in memory sorts- Niall Litchfield
» RE: trace to find time spent in memory sorts- TJ Kiernan
» Re: trace to find time spent in memory sorts- Kurt