Call: +44 (0)1904 557620 Call

Pete Finnigan's Oracle Security Weblog

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

[Previous entry: "Nice post on Amis about flasback"] [Next entry: "Tom writes about anonymous postings"]

Another nice flashback paper

I noticed that Lucas mentioned Jim Czuprynski's paper on flashback in his Amis blog post. I also noticed this paper yesterday and made a note of it. Jim's paper is called "Oracle 10g Availability Enhancements, Part 3: FLASHBACK Enhancements" and is the third part of a three paper series. This is a great paper as usual from Jim that starts with a review of flashback queries with examples and then goes on to talk about flashback version query with an illustration, then the new pseudo column ORA_ROWSCN is then discussed. Flashback transaction queries are discussed again with examples before Jim finishes with a short discussion of using SCN's vs timestamps and finally a discussion of the effects of the UNDO_RETENTION settings. This is a good paper.