Re: High TEMP tablespace IO rate

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Wed, 13 Sep 2000 18:00:16 GMT
Message-ID: <39BFC0B0.9A9691EA@edcmail.cr.usgs.gov>

> Sounds like you are doing lots of sorts and/or index builds. You may be
> able to minimize sorting via indexes. Get the SQL from v$sql with the
> highest number of sort i/o's, and perform explain plans on it.

One could also increase the SORT_AREA_SIZE to cause more sorts to be performed in memory rather than on disk.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Wed Sep 13 2000 - 13:00:16 CDT