Re: Why tablespace Full?

Thank you for your help. But I still have two problems that is why the temporary tablespace continue to expand ( 2G at inital but 6G now). I have check the view v$sort_segment and v$sort_usage that usage is very low but it still continue to expand. Can anybody tell me whether the temporary tablespace can not be reuse or share by other? How can decrease the size of the temporary tablespace when DB online?

Thanks in advance

Antony

Mark D Powell wrote in message <949hm2$cjm$1_at_nnrp1.deja.com>...
>In article <3a67b2a8_at_newsgate.imsbiz.com>,
> "Antony Mak" <cheong_at_broadway-ps.com> wrote:
>> I have found that it is a temporary segment for sorting. But why the
>> tablespace can not be reuse by others and continue to extent?
>>
>> Thanks in advance
>>
>> Antony
>>
>If you have the tablespace defined as type temporary then unless you
>are running OPS or have multiple temp tablespaces assigned then Oracle
>will allocate one temp segment for the entire db. Multiple user
>sessions will use this one segment. You can see sort segment
>allocation and usage information using v$sort_segment and v$sort_usage.
>
>--
>Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
>
>Sent via Deja.com
>http://www.deja.com/
Received on Fri Jan 19 2001 - 19:40:41 CST