Re: High TEMP tablespace IO rate

From: David Sisk <davesisk_at_ipass.net>
Date: Wed, 13 Sep 2000 15:38:51 GMT
Message-ID: <fcNv5.2836$IV1.891253@typhoon.southeast.rr.com>

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.

Paul A. Durnoff <dpa_at_mail.ru> wrote in message news:8pn7ql$m93$1_at_ns.metacom.ru...
> Hello,
>
> Could somebody give me an advice:
> I discovered that TEMP tablespace in one instance has very high number of
IO
> operations, about in three times higher than the DATA tablespace. Why? How
> to fix it? May be it is not a problem?
> All data is stored in DATA tablespace, indexes in INDX. All users have the
> TEMP tablespace as temorary.
>
> Thanks,
> Paul A. Durnoff
> dpa_at_mail.ru
>
>
>
Received on Wed Sep 13 2000 - 10:38:51 CDT