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

Home -> Community -> Usenet -> c.d.o.server -> Re: Excessive Logical and Physical I/O

Re: Excessive Logical and Physical I/O

From: srivenu <srivenu_at_hotmail.com>
Date: 18 Mar 2004 01:41:33 -0800
Message-ID: <1a68177.0403180141.266e51bb@posting.google.com> 





> My first suspicions were due to the sort, but I would have expected

> the sorts to be done via direct I/O (i.e. bypassing the buffer cache).

> Anyone have any ideas why this is performing so much work...




I dont think it is due to sorting as you have returned only 263 rows.



It would have been good if you pasted the entire TKPROF.
regards


Srivenu
Received on Thu Mar 18 2004 - 03:41:33 CST












Original text of this message













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