Re: trace to find time spent in memory sorts
From: Lei Zeng <leizeng2003_at_yahoo.com>
Date: Wed, 22 Feb 2012 23:15:51 -0800 (PST)
Message-ID: <1329981351.60648.YahooMailNeo_at_web114704.mail.gq1.yahoo.com>
Would you turn on 10046 trace for the sql?
For example,
SORT ORDER BY (cr=3 pr=0 pw=0 time5 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_at_banfield.net> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Wednesday, February 22, 2012 6:11 PM Subject: trace to find time spent in memory sorts
Date: Wed, 22 Feb 2012 23:15:51 -0800 (PST)
Message-ID: <1329981351.60648.YahooMailNeo_at_web114704.mail.gq1.yahoo.com>
Would you turn on 10046 trace for the sql?
For example,
SORT ORDER BY (cr=3 pr=0 pw=0 time5 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_at_banfield.net> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> 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.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 23 2012 - 01:15:51 CST