Problem in Temporary tablespace.

From: Truc Nguyen <truc_at_nguyen.as>
Date: Tue, 31 Oct 2000 10:56:36 +0100
Message-Id: <10666.120650@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0142_01C04329.3CDCD740 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi listers,

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 often = full.
Does any one know why and how can i get rid of this problem ?

Thanks a lot.

Nguyen=20

------=_NextPart_000_0142_01C04329.3CDCD740 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4308.2900" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>        Hi listers,</DIV>
<DIV> </DIV>
<DIV>    We have some average databases in version=20
8.0.4.2.1.</DIV>
<DIV>The temporary tablespace is very big (untill 10 gig) but it's very =
often=20
full.</DIV>
<DIV>Does any one know why and how can i get rid of this problem ?</DIV>
<DIV> </DIV>
<DIV>    Thanks a lot.</DIV>
<DIV> </DIV>
<DIV>    Nguyen </DIV></BODY></HTML>

------=_NextPart_000_0142_01C04329.3CDCD740-- Received on Tue Oct 31 2000 - 03:56:36 CST