I have seen this exact behavior too.
FWIW. Mike
-Original Message-
Sent: Friday, July 26, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
Lisa,
I've had problems with TEMPORARY tablespaces in Version 7.
Busy databases continually ran out of TEMP space, and it would
not get rel
Lisa,
I've had problems with TEMPORARY tablespaces in Version 7.
Busy databases continually ran out of TEMP space, and it would
not get released for use by other sessions.
We finally went back to PERMANENT temp TBS's on version 7
and the problems disappeared. I haven't experienced this on 8+.
ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Help on Temp Space
put it offline and again online immediately...do it at off-peak time ,
tested solution...
Regards
rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Dat
put it offline and again online immediately...do it at off-peak time ,
tested solution...
Regards
rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 26 Jul 2002 08:09:14 -0800
Hi all,
Still on 7.3.4, and can't seem to free up the temp