Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sorts and IO in the temporary tablespace
Most. If you analyze an object or build an index you can use temporary
table space.
Jim
"dias" <ydias_at_hotmail.com> wrote in message
news:55a68b47.0112060721.3fc814c3_at_posting.google.com...
> Hi,
>
> I have a big diffrence between the sorts in the SYSSTAT section of a
> report.txt and IO on the temporary tablespace.
>
> - Sorts (disk) = 16
> - Temporary tablespace:
> - READS = 7794
> - BLKS_READ = 95301
> - WRITES = 11999
> - BLK_WRT = 11999
>
> My question is what is the relation between the number of sorts and
> the IO in the temporary tablespace. Are all IO in the temporary
> tablespace caused by sorts or not ?
>
> Thanks
Received on Thu Dec 06 2001 - 09:59:37 CST