Hi Dave,
No. temporary tablespaces provide a performance gain by not de-allocating extents. The next transaction that needs the temp tablespace can utilize extents that are already allocated, thus bypassing the overhead of allocating the extents.
That's the idea behind it anyway. I always ignored temp when determining if coalescing is necessray in the database.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117
-----Original Message-----
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 7:23 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: coalesce tablespace
Does this also apply to a temporary tablespace?? I have a temp TS that has
a percent extents coalesced of 1.
Thanks,
Dave
-----Original Message-----
Sent: Thursday, September 20, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L
Following script may be used to check whether coalesing is required or not.
If lasr column not 100% then coalesce that tbs....
select substr(tablespace_name,1,10)TS_NAME,total_extents
"Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0)
from dba_free_space_coalesced
/
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 20 Sep 2001 12:21:21 -0800
It would take contiguous free extents and make them larger extents, which
would be more likely to reuse. Especially if there are many smaller ones,
this moot if using LMT.
It is a very quick procedure and good to do occasional, you can check in
dba_data_files_coalesced to see if the number is far from 100%, if it is
less than 75% or so, just throw a coalesce on the tablespace.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
Sent: Thursday, September 20, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L
We have tablespaces in acceptance and production that are being resized for
growth. Pctincrease is set at 0. Would it also help to coalesce the
tablespace? What are the benefits of this command?
Thanks,
Sandi
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
