Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Temp tablespace

RE: Temp tablespace

From: Klavers, Richard <R.Klavers_at_arbeidsbureau.nl>
Date: Wed, 3 May 2000 09:58:36 +0200
Message-Id: <10486.104769@fatcity.com>


Hi,

I found a book which went a little deeper on the TEMP tablespace in Oracle 7.3.
The book says that the first sort to use the temp tablespace allocates a temporary segment within the temp tablespace, and when the query completes, the space used by the temporary segment is not dropped. Instead, the space used by the temporary segment is available for use by other queries. This avoids the cost of allocating and releasing space for temporary segments. So a temp tablespace can fill up to 100% and stay that way, even if no one is using sorts.
You can not see who or what is using the TEMP tablespace, only what amount of space is being used.
The book i found this in is the Oracle DBA Handbook 7.3 edition from Oracle Press by Kevin Loney.

As you can see, it all comes down to RTFM. Next time i will read first and then ask...

Richard Klavers

> ----------
> Van: Lyall Barbour[SMTP:lyallbarbour_at_sanfranmail.com]
> Antwoord naar: ORACLE-L_at_fatcity.com
> Verzonden: woensdag 3 mei 2000 3:44
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: 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------
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: May 2, 2000 7:57:32 PM GMT
>
>
> 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
>
> --
> Author: Lyall Barbour
> INET: lyallbarbour_at_sanfranmail.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
Received on Wed May 03 2000 - 02:58:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US