Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Timestamps in trace files (and other trace file oddities)

Re: Timestamps in trace files (and other trace file oddities)

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 24 Jul 2003 19:42:03 -0600
Message-Id: <26007.339497@fatcity.com>


If the sort requires disk you'll the direct write/reads in the trace. They do not count towards LIO and PIO as they are not using the buffer pool.

At 03:49 PM 7/24/2003 -0800, you wrote:

>Another significant area of processing can be sorting. I don't know if
>sort processing is counted along with LIOs or PIOs.
>
>Dan

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com Received on Thu Jul 24 2003 - 20:42:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US