Re: TRUNCATE Before Drop ???

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Thu, 26 Apr 2007 11:47:21 -0700
Message-ID: <3b0f44a10704261147i6c92b572t2bbb5e9e089c9169@mail.gmail.com>

BN,

There are few optimizations for drop table and truncate table in the recent versions. However you need to have couple of underscore parameters (means unsupported) set with the correct granule size.

If that is a test database, you can use

_drop_table_optimization_enabled=True with a bigger granule size (say 1024) for the _drop_table_granule.. I think (optimized) truncate can also be enabled with the parameter _truncate_optimization_enabled .

Standard disclosures apply !!!

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 26 2007 - 13:47:21 CDT