Re: who is using sort space?

From: SatarNag <satarnag_at_aol.com>
Date: 1997/08/12
Message-ID: <19970812172401.NAA18402@ladder02.news.aol.com>#1/1

>Phil Cook <pcook_at_iamerica.net> wrote in article
><01bca3a0$9e8f0840$92f9adcd_at_phil-cook-laptp>...
>> Look in all_tables where tablespace = 'TEMP'
>>
>> Phil Cook
>
>Yes, but SYS owns them all!
>

What was the Question?
Sort_area_size is an assigned limit memory area where Oracle conducts it's sorts, if the Sort_area_size is too small, then Oracle writes the information to a temporary table space. It is Ideal to have the majority of sorts done in memory. The table space in which Oracle writes it's sorts too, is owned by System.

Satar Naghshineh
Entry-Level Oracle DBA
SatarNag_at_aol.com Received on Tue Aug 12 1997 - 00:00:00 CDT