Hi Russ,
Yes, a bounce will not achieve anything, and neither will a full table scan if
it is done in parallel or if 'delayed_logging_block_cleanouts' is TRUE (which is
the default at 7.3 and 8.0).
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
--
Hi,
What you are doing is the right (and AFAICR is the only) choice. I might
add that if you knew the tables that were modified, then an FTS on only
those table would suffice.
- Kirti Deshpande
> -Original Message-
> From: Russell Brooks [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, Februar
Hi,
You are right bouncing the database won't do the trick. The next access to
the block will do the cleanout no matter if the database has gone down in
between.
Jack