366: Internals of transaction recovery inside of Oracle Block and Redo logs with Block dump – Live Demo.
Sandip Patel , Abbott Labs    Biography

Objectives: Watch the transaction recovery inside Oracle block and redo log file by dumping block into text file
Read the transaction inside the redo log file by LogMinor and understand the transaction recovery.
Dump Oracle data block and undo block to read data inside the block to understand the transaction.
Abstract: Understand the Oracle Block internals, how oracle handles the transaction inside the Data block. Understand the internals Oracle’s ROLLFORWARD and ROLLBACK to protect the committed and uncommitted data during the instance crash. Understand the role of redo log files and undo block in the recovery of transaction. How to read undo and redo inside the related redo log files. Speaker will demonstrate the live transaction inside the oracle block by dumping block to the text file. Find the undo – Redo blocks and data inside the block. He will also explain the internals of how oracle does the transaction recovery on the instance crash. Presentation will also cover the overall internal structure of Oracle block, How to read the header of the block and data inside the block. Attendees will have a very good and clear understanding about the internals of the transaction moving inside the oracle block along with the internals of the transaction recovery.

Audiernce Focus: DBA
Expertise: Advanced
Track: Database
Date: Wednesday, April 16, 2008
Time: 1:30 PM - 2:30 PM