Sorts and IO in the temporary tablespace

From: dias <ydias_at_hotmail.com>
Date: 6 Dec 2001 07:21:21 -0800
Message-ID: <55a68b47.0112060721.3fc814c3@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:21:21 CST