Re: TRUNCATE Before Drop ???

On 4/26/07, K Gopalakrishnan <kaygopal@xxxxxxxxx> wrote:


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/



Greetings and Thank  you for your

Jared, A few of our databases are still sitting in 81.7.4 , As usual we are
short on disk space,
DEV Team and App Prod Support Team came up with  a few old tables they used
during conversion which were retained as part of business requirement.

Now they have decided to drop these tables to release space for us.

Given a chance I would like test this with 10046 level 12 trace  in all
versions, but the only test system I have now is 10gRel2.

--
Regards & Thanks
BN

Other related posts: