Re: truncate a table with many extents

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 6 May 2004 16:02:32 +0100
Message-ID: <00dd01c4337b$285f1350$7102a8c0@Primary>

Shouldn't make a significant difference. The undo and redo would only be about
the data dictionary.

There may be some versions of Oracle where the different actions produce a different number of updates on seg$ or tsq$, though, but that's just a random thought.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st

• Original Message ----- From: "Powell, Mark D" <mark.powell_at_eds.com> To: <oracle-l_at_freelists.org> Sent: Thursday, May 06, 2004 3:45 PM Subject: RE: truncate a table with many extents

If I am not mistaken dropping the table should be much worse than using truncate because the use of drop would greatly increase the amount of undo that Oracle has to keep track of.

• Mark D Powell --

  ---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu May 06 2004 - 10:02:15 CDT