RE: Temp tablespace

I've looked for that also. The only user that puts things in that tablespace is SYS. I'm not sure, if you do find out, let me know! :)

Sorry
Lyall Barbour

------Original Message------
From: "Klavers, Richard" <R.Klavers_at_arbeidsbureau.nl> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: May 2, 2000 7:57:32 PM GMT
Subject: Temp tablespace

Hi,

is there a way to see which user or process is consuming the TEMP tablespace?
The tablespace is created as a 'TEMPORARY' tablespace. I've looked in all kinds of documentation, and you can find all sort of things
about rollback segments and memory and so on, but nothing is said about the TEMP tablespace.

Regards, Richard Klavers

--
Author: Klavers, Richard
INET: R.Klavers_at_arbeidsbureau.nl

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).

______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup