Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sorts and IO in the temporary tablespace
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<JBMP7.2912$ER5.246119_at_rwcrnsc52>...
> 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
Another one is Sort-Merge Joins. Depending on the size of the tables, this one can take lots of temp segments and generate tons of IOs.
-bass Received on Thu Dec 06 2001 - 15:09:40 CST