Flashback Transaction Query
Another new flashback query feature introduced with Oracle 10g is flashback transaction query. The new flashback transaction query feature allows users to review and/or recover modifications made to the database at the transaction level—meaning that users can use this new feature to diagnose and resolve logical problems, perform historical analysis, or even audit transactions from a single transaction or by all the transactions during a period of time. Prior to 10g, DBAs had to mine redo logs with LogMiner to extract specific transactional information to possibly correct or audit SQL statements. Now, with flashback transaction query, you can undo the effects of a bad transaction much more quickly than before by querying ...
Get Oracle® Database 10g Insider Solutions 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.
