Re: Problem in Temporary tablespace.

hi

in some cases u need to force smon to do the cleanup. this can be done = aby
altering one of the temp tablespace parameters. actually the value of t= he
parameters do not matter. so u can issue command with the new parameter=

same as the existing one...

babu

Truc Nguyen <truc_at_nguyen.as>@fatcity.com on 10/31/2000 05:00:58 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: Problem in Temporary tablespace.

=A0=A0=A0 =A0=A0=A0 Hi listers,

=A0=A0=A0 We have some average databases in version 8.0.4.2.1.
The temporary tablespace is very big (untill 10 gig) but it's very ofte= n
full.
Does any one know why and how can i get rid of this problem ?

=A0=A0=A0 Thanks a lot.
Received on Tue Oct 31 2000 - 10:09:26 CST