| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Speed up Truncate tables
truncate doesn't change the hwm unless you drop storage
also, depending on the number of extents (not the number of rows), it can take a long time to free up storage if you do truncate table ... drop storage.
Oracle has to update the UET$ and FET$ tables for each extent you release.
>From: Hallas John <John.Hallas_at_btcellnet.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Speed up Truncate tables
>Date: Wed, 15 Aug 2001 01:25:59 -0800
>
>Chuan,
>
>Are you sure you were using the TRUNCATE TABLE command rather than DELETE
>It sounds as if you are running a delete, especially if the HWM was not
>shrunk
>
>John
>-----Original Message-----
>Sent: 15 August 01 09:10
>To: Multiple recipients of list ORACLE-L
>
>
>Hi All,
>
> Is there any way to speed up the truncating a big table with 12
>million
>rows?
>
>Basically, I implemented truncating that big table on Production, but it
>affected the performance much, so I had to stop it in the middle of way.
>All
>the rows were truncated but the HWM was not shrunk at all. I want to do it
>again to get the space back. Is there any way to speed up this process?
>
>Platform: Oracle EE8.0.6 and Solaris 2.7
>
>Thanks a lot in advance.
>
>Chuan
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Chuan Zhang
> INET: chuan_at_asiaonline.net
>
>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).
>
>
>
>**********************************************************************
>This email and any attachments may be confidential and the subject of
>legal professional privilege. Any disclosure, use, storage or copying
>of this email without the consent of the sender is strictly prohibited.
>Please notify the sender immediately if you are not the intended
>recipient and then delete the email from your inbox and do not
>disclose the contents to another person, use, copy or store the
>information in any medium.
>**********************************************************************
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_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).Received on Wed Aug 15 2001 - 09:50:37 CDT
 |
 |