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 -> sorting out to disk - question

sorting out to disk - question

From: mlm <nunya_at_business.com>
Date: Wed, 22 Aug 2001 14:17:54 -0400
Message-ID: <3B83F752.D57596B4@business.com> 





Oracle 8.0.5.25


NT 4.0 SP6


1 GB RAM


I've determined that we have some sorting to disk going on in the
database.  How can I find out what SQL statements are causing this?
I've checked v$sqlarea, and there is a column that gives you the number
of sorts for a particular query, but it doesn't specifiy whether it's a
memory or disk sort.



Any ideas?



Thanks,


mm
Received on Wed Aug 22 2001 - 13:17:54 CDT












Original text of this message













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