What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table?
- From: Paresh Yadav <yparesh@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 5 Jul 2011 21:30:50 -0400
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
- Follow-Ups:
Other related posts:
- » What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Paresh Yadav
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Tanel Poder
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Saibabu Devabhaktuni
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Tim Gorman
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Jonathan Lewis
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Jonathan Lewis
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Saibabu Devabhaktuni
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Jonathan Lewis
- » RE: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Mark W. Farnham
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Saibabu Devabhaktuni
- » RE: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Mark W. Farnham
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Jonathan Lewis
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Hua Cui
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Saibabu Devabhaktuni
- » RE: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Mark W. Farnham
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Jonathan Lewis
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Paresh Yadav
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Jonathan Lewis
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Paresh Yadav
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Saibabu Devabhaktuni
- » Re: What is the purpose of segment level checkpoint before DROP/TRUNCATE of a table? - Tanel Poder