Re: TRUNCATE Before Drop ???

On 4/26/07, K Gopalakrishnan <kaygopal_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l