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
