Re: Temporary Tablespace - Filling up

Look for any process/sql on your system which is resulting in a cartesian join using lot of temp tablespace....
Regards

MOHAMMAD RAFIQ Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thu, 02 Aug 2001 23:40:24 -0800

Hi Gurus,

I have a problem, perhaps someone can shed some light on this, please, I have a temporary Tablespace, which keeps on running out of space. At first I would increase the size, yet it still keeps filling up. Failing to be able to extend, until I increase it again.
The object in the tablespace is owned by SYS and is called 11.2 Does anyone have any idea what is causing this and where it originates from, and what the object is, because it is not a table?(As far as I can see). The OS platform is Windows 2000
Oracle Version is 8.1.7.

Thank You
Denham

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Denham Eva
   INET: EvaD_at_TFMC.co.za

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).