Re: TRUNCATE Before Drop ???

  • From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
  • To: bnsarma@xxxxxxxxx
  • Date: Thu, 26 Apr 2007 11:47:21 -0700


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

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006

Other related posts: