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: "Tools page updated"] [Next entry: "Database user account status's in SYS.USER_ASTATUS_MAP"]

Mark has a good post about the new 10g Release 2 version

I was just surfing over at Mark Rittman's weblog and found an interesting post entitled "Looking Forward To Oracle 10g Release 2". 10g Release 2 was of course announced at Oracle Open World and I have made a few blog entries here about it around that time, 10g Release 2 on the way?, Oracle Database 10g Release 2 keynote at Oracle Open World, Two more accounts of the Chuck Rozwat 10g R2 keynote at OOW , Justin talks more about the 10g R2 keynote at OOW and Oracle have made a press release about the database 10g release 2 announcement .

Marks account of the release is quite interesting as he sees it as I do as not a major upgrade on 10g R1 but in fact a fixing and tweaking exercise. Mark even suggests that some of the new changes may come as patch upgrades to 10g R1.

Mark goes on to talk about the key new features and changes. He talks about the new transparent encryption and key management within the database. Let's hope as Mark suggests that in a later release the key management facilities are expanded. Mark also points out that data in tables that use this feature will be written to backup in an encrypted state.

Mark also talks about the direct SGA access for statistics gathering and then goes on to talk about the coming .NET CLR support in 10g R2 and speculates on the levels of support that are going to be available. Mark's impression is that it will work initially through the EXTPROC features and possibly later be fully integrated in the same way as Java and PL/SQL are supported.

XQuery is also discussed as is the new PL/SQL API for data mining and a few other bits. The interest for me is the encryption, SQA direct access and the .NET CLR being integrated.