Tuesday 13 March 2007

Oracle Enterprise Manager 10gR3 Launch Webcast

Oracle held a live webcast today to announce the latest release of its Enterprise Manager product, 10g Release 3 (10gR3). (If you missed it, you can catch a replay.)



The webcast was hosted by Charles Phillips, president of Oracle, as well as Richard Sarwal, SVP, Applications and Systems Management. The fact that they have a SVP level executive overseeing Enterprise Manager indicates they're serious about moving this oft-maligned product forward.



The theme of the webcast was "Top-Down Application Management." The message was that unlike most systems management solutions, which are focused on monitoring "bottom-up," the underlying infrastrucure beneath applications, the new version of Enterprise Manager is designed to monitor applications directly, the top of Oracle's "stack". You can code service level agreements in the form of policies, and OEM will monitor which applications and underlying objects are performing within their SLAs. You can drill down on those that aren't to see what the problem is.



The speakers also made a distinction between systems management products that are "viewers" as opposed to "doers". All such products include dashboards to monitor thresholds and report violations. But OEM is designed to let you directly do something about it as well.



The key drivers that are making this an important product for Oracle are the increasing complexity of always-on, multi-product, multi-vendor, mission critical systems; and the increasing requirements for regulatory compliance not just in the U.S. but around the world.



The phrase, "Complete and Open" captured the intent of what OEM is to become. The new version will include adapters for SAP, WebSphere, and Microsoft Operations Manager (MOM) as well as for Oracle's own products. Features will be standards-based for interoperability.



One of the more fascinating parts of the show were the cutaways to Mark Sunday, CIO, at Oracle's data center in Austin, TX. Video segments showed some of the 23,000 servers and 5PB (that's PETAbytes) of storage in house, used both for Oracle's own internal processing and to support their Oracle On Demand service. The control center reminded me of the tour I took recently of Johnson Space Center in Houston: large display monitors covered the front wall, with the rest of the room dedicated to individual workstations. Appropriate image for a product "launch."



Oracle Tips - February 2007

Here are my Oracle Tips columns published at TechRepublic.com during February, 2007:



Hide Sensitive Data with Oracle 10g Column Masking - February 6, 2007
Oracle 10g's Virtual Private Database (VPD) feature has the ability to automatically mask out (set to NULL) certain columns in the results of a query on a row-by-row basis. This tip shows how to create a VPD policy that requests the column masking option.



Trade Risk for Speed with Oracle 10g's Asynchronous Commit - February 13, 2007
A new option to the COMMIT statement in Oracle 10g can defer the writing of committed data to the online redo log files. This involves a risk of data loss, but it speeds up the transaction response time. Find out more details in this tip.



Delete Rows During Updates using Oracle 10g's Merge Statement - February 20, 2007
In Oracle 10g Release 1, the MERGE statement gained the ability to delete rows, as well as update and insert them. This Oracle tip shows you how it works.



Move SQL Tuning Sets between Oracle Instances - February 27, 2007
SQL Tuning Sets (STS) capture the workload of an Oracle instance. Starting in Oracle 10g Release 2, these tuning sets can be transported from one instance to another to facilitate testing.