What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table?
Date: Tue, 5 Jul 2011 21:30:50 -0400
Message-ID: <CAPXEL0LrX8H2Mu0wL6H4J0AZ3tRA9EcGnhpQBofJqvyHeEOWWA_at_mail.gmail.com>
Hi,
What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? I have tried to find this since quite some time, Only thing I have found is that it is required for recoverability, specifically point in time recovery amongst many other things. I have read about it on so many sites (as far as I remember Jonathan Lewis, Tom Kyte etc.). I recently saw an awesome article on check points by Harald Van Breederode titled "What's the Point of Oracle Checkpoints?". How does it help in recoverability? I thought about point-in-time recovery. All the information to recover dirty buffers for committed transactions should be in the redo stream (redo log and/or archived log) so why do a checkpoint at the object level before truncat//drop? Is it to shorten MTTR etc.? An explanation will be very much appreciated. Any pointers to other resources that I can read in this matter?
--
Thanks
Paresh
416-688-1003
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 05 2011 - 20:30:50 CDT