Re: High TEMP tablespace IO rate

From: Roman Starek <starek_at_pluto.spsselib.hiedu.cz>
Date: 13 Sep 2000 13:56:52 GMT
Message-ID: <8po134$luc$1@crax.cesnet.cz>

: 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

There is probably so many sorts going to disk try to find which session is doing sorts via v$sysstat v$sesstat where name like 'sorts%'. In this case try to increase sort_area_size init ora parameter. Or try to rewrite problematic query not to use index.

Starous Received on Wed Sep 13 2000 - 08:56:52 CDT