Summary
In this chapter, we broke down an Oracle database into its smallest pieces—both logically and physically. We examined common threads on how to track transactions by Xid, SCN, and Timestamps. The physical components should be very clear to you as well—undo segments, redo logs, archived logs, and database files. And most important of all: how transactions travel through the physical parts of the database, from when the end user types in a change, to a row in a table identified by a rowid on a particular data block on a physical data file.
Several utilities were covered along with appropriate scenarios and suggested uses:
- Oracle's RDBMS SQL command
dump block - Oracle's RDBMS Log Miner utility
- Flashback Transaction Query and Backout
- Unix
strings ...
Get Oracle Database 11g—Underground Advice for Database Administrators now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
