When we were maintaining a 3-node RAC system in a test/dev environment (lots
of truncating initially), we wound up adding "...reuse storage" because the
truncate table commands were taking an enormous amount of time coming back.
On 3/15/06, Gints Plivna <gints.plivna_at_gmail.com> wrote:
>
> Probably using temporary tables if these fits your needs?
>
> Gints
>
> 2006/3/15, Hameed, Amir <Amir.Hameed_at_xerox.com>:
> > Folks,
> > It seems that truncating a table under RAC is more expensive than
> > truncating it under a single instance
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 15 2006 - 10:52:38 CST
