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.
Blog
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"]
May 2005
- A free script to find hidden users in your database - 05/01/2005 by 05/01/2005
- Alex has updated his Oracle exploits page to add 5 more exploit codes - 05/02/2005 by 05/02/2005
- alpha copies of two chapters of Tom's new book are available - 05/04/2005 by 05/04/2005
- Another nice flashback paper - 05/05/2005 by 05/05/2005
- Tom writes about anonymous postings - 05/07/2005 by 05/07/2005
- Richard talks about diagnostics support pack and applications collection tool (ACT) - 05/09/2005 by 05/09/2005
- A great example of information leakage! - 05/10/2005 by 05/10/2005
- A nice paper on latch internals - 05/11/2005 by 05/11/2005
- Nice list of Oracle's default ports - 05/12/2005 by 05/12/2005
- A select only user causing locks? - 05/13/2005 by 05/13/2005
- Marcel-Jan has an interesting tool on his site called SQL-Gotcha - 05/15/2005 by 05/15/2005
- nice paper by Doug Burns on Oracle parallel execution tuning - 05/16/2005 by 05/16/2005
- SQLGotcha is on freshmeat - 05/17/2005 by 05/17/2005
- A good paper on Oracle's random number generator - 05/18/2005 by 05/18/2005
- A good description of some of the Oracle default accounts - 05/20/2005 by 05/20/2005
- orablogs is back - 05/21/2005 by 05/21/2005
- A good list of Oracle discussion resources - 05/22/2005 by 05/22/2005
- IDG were scheduled to interview Oracle's CSO - 05/24/2005 by 05/24/2005
- Scarlet Pruitt's interview with Mary Ann Davidson is out - 05/25/2005 by 05/25/2005
- Alex is to talk at ITUnderground Warsaw and DOAG Freiburg - 05/26/2005 by 05/26/2005
- A new short paper on Alex's site - How to change XMLDB Ports - 05/28/2005 by 05/28/2005
- Chris was also talking about Alex's 42 bugs found in Metalink - 05/30/2005 by 05/30/2005
- Alex has released his paper on metalink hacking - 05/31/2005 by 05/31/2005
Archives
Syndication
Powered by gm-rss 2.0.0
