Whittle Jerome Contr NCI,
I think your sql should not work on a really TEMPORARY tablespace, and
temporary tablespace do not need to be cleaned either.
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
======= 2003-02-11 06:49:00 ,you wrote��=======
>Hi,
>
>This is what I use to clean up a temp tablespace. The tablespace is named 'temp' and
>it is normally set to PCTINCREASE of 10. You will need to insert the correct values
>for your temp tablespace. Altering the tablespace a little wakes us SMON which will
>clean things up if it can.
>
>alter tablespace temp default storage(pctincrease 0);
>alter tablespace temp default storage(pctincrease 10);
>
>50Mb seems rather small for a temp tablespace.
>
>Jerry Whittle
>ASIFICS DBA
>NCI Information Systems Inc.
>[EMAIL PROTECTED]
>618-622-4145
>
>> -----Original Message-----
>> From: Zabair Ahmed [SMTP:[EMAIL PROTECTED]]
>>
>> Is their any way of identifying which user/process is holding onto a temporary
>segment. I've got a 50Mb temporary tablespace and there is a temporary segment which
>is 47Mb which is not being freed up by SMON.
>>
>> And, if i can't identify who is holding onto this TEMP segment, is their a way in
>which I can delete it and stop the alert log being flooded with ORA-1652.
>>
>> As I say the SMON is failing to clean up this TEMP segment and it's been on-going
>for a number of days and I don't have the option of bouncing the database.
>>
>> Oracle 8.1.7.3 on HP-UX 11.
>>
>> TIA
>>
>>
>>
>> _____
>>
>> With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
><http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storage.html>
>>
= = = = = = = = = = = = = = = = = = = =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: chao_ping
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
