Re: trace to find time spent in memory sorts
- From: Lei Zeng <leizeng2003@xxxxxxxxx>
- To: "Josh.Collier@xxxxxxxxxxxx" <Josh.Collier@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Feb 2012 23:15:51 -0800 (PST)
Would you turn on 10046 trace for the sql?
For example,
SORT ORDER BY (cr=3 pr=0 pw=0 time?5 us)
The 'time' is a total of 'SORT' operation and its sub-steps. Please remember to
subtract 'time' of its sub-steps from it.
Lei
DBspeed http://www.dbspeed.com/index.html
________________________________
From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, February 22, 2012 6:11 PM
Subject: trace to find time spent in memory sorts
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:
