Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Temp tablespace
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
![]() |
![]() |