Re: use temporary tablespace details

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 30 Jul 2006 14:35:46 -0700
Message-ID: <1154295347.133341@bubbleator.drizzle.com>

aman.oracle.dba wrote:

> Oracle 9.2.0.7 and it is temporary tablespace,
> And how could we come to know when to go for deallocate or colesce.
> 
> Brian Peasland wrote:

>> aman.oracle.dba wrote:
>>> Actually my database temporary tablespace is increasing very fast day
>>> by day. I just want to know why and how.... means I thought space is
>>> deallocated when sorting is over when
>>> sorting is in auto mode and I have configured
>>> PGA_AGGERATE_TARGET.............
>>> or I have to deallocate the space. If yes then how.........
>> Which version of Oracle? Was your tablespace created with TEMPFILES or
>> DATAFILES?
>>
>> Cheers,
>> Brian
>>
>> --
>> ===================================================================
>>
>> Brian Peasland
>> dba_at_nospam.peasland.net
>> http://www.peasland.net
>>
>> Remove the "nospam." from the email address to email me.
>>
>>
>> "I can give it to you cheap, quick, and good.
>> Now pick two out of the three" - Unknown

You did not answer the question. We know it is a temporary tablespace ... how was it made?

select file_name from dba_temp_files;

Does that return the name?

That said ... you are almost undoubtedly looking in the wrong place. First tune the application.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Jul 30 2006 - 16:35:46 CDT