Oracle Product Plans for HP Platforms: OpenVMS

1. 1 Oracle Product Plans for HP Platforms: OpenVMS Sandy Vella Sandy.Vella@oracle.com September 27, 2006

2. 2 The following is intended to outline our general product direction. It is intended for information purposes only and may not be incorporated into a contract or agreement. It is not a commitment to deliver any material, code, or functionality, and it should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle�s products remains at the sole discretion of Oracle.

3. 3 HP, Oracle, Intel Integrity Web Event Back in march, the CEOs from Intel, HP and Oracle appeared in a live web broadcast to jointly express commitment to Itanium and Integrity servers. Back in march, the CEOs from Intel, HP and Oracle appeared in a live web broadcast to jointly express commitment to Itanium and Integrity servers.

4. 4 Oracle | Hewlett Packard Resources We have a team in place worldwide that for HP/Oracle�.This team brings issues to light (escalation) from the field�This helps us focus on any out of the ordinary issues that are taking place worldwide, these individuals also act a a conduit to customers the other way as well. If so some reason, we need to ask customers in the field about an issue. This mechanism was just used for example, to receive requests for the 10gR2 OpenVMS Itanium early drop program. Then the drops were in turn distributed thru the field as well. We have a team in place worldwide that for HP/Oracle�.This team brings issues to light (escalation) from the field�This helps us focus on any out of the ordinary issues that are taking place worldwide, these individuals also act a a conduit to customers the other way as well. If so some reason, we need to ask customers in the field about an issue. This mechanism was just used for example, to receive requests for the 10gR2 OpenVMS Itanium early drop program. Then the drops were in turn distributed thru the field as well.

5. 5 Oracle Roadmap - OpenVMS Current Highlights include 10gR1 on Alpha and 10gR2 on I64 production releases. In Q4CY06, Oracle plans to provide support and certification for VMS V8.3 on Alpha and I64. In Q4CY06, Oracle plans to deliver 10gR2 on Alpha. Alpha 9i and 10g will continue to be supported. Next database releases will be I64 only.Current Highlights include 10gR1 on Alpha and 10gR2 on I64 production releases. In Q4CY06, Oracle plans to provide support and certification for VMS V8.3 on Alpha and I64. In Q4CY06, Oracle plans to deliver 10gR2 on Alpha. Alpha 9i and 10g will continue to be supported. Next database releases will be I64 only.

6. OpenVMS Roadmap & Directions Itanium Oracle Database 10gR2 New major database releases to be ported to OpenVMS Itanium only (Aka 11g and on�.) Alpha Oracle Database 10g porting through terminal release Support until at least 2011 Application Server & E-Business Suite Split Configuration (VMS as backend database server) Support until at least 2011 10g continued support on Alpha through at least 2011. Future releases will be I64 only.10g continued support on Alpha through at least 2011. Future releases will be I64 only.

7. 7 OpenVMS Teams at Oracle Oracle Corporate/Oracle Nashua Base porting, quality assurance, stress testing, error diagnosis and error correction Product management, documentation OpenVMS Engineering team working extremely closely with Oracle Oracle OpenVMS support dedicated resources in EMEA and US II

8. 8 I64 Multi-Core Licensing While other multi-core processors have different licensing factors, for AMD and Intel chips, the factor is one-half. This means that a system with 4 processors and 8 cores uses a processor factor of 8 * .5 = 4.While other multi-core processors have different licensing factors, for AMD and Intel chips, the factor is one-half. This means that a system with 4 processors and 8 cores uses a processor factor of 8 * .5 = 4.

9. 9 Oracle Rdb Status Update Norman Lastovica Norman.Lastovica@oracle.com September 30, 2006

10. 10 Oracle�s commitment to Rdb and Itanium expressed here. High-performance OLTP, quality and stability.Oracle�s commitment to Rdb and Itanium expressed here. High-performance OLTP, quality and stability.

11. 11 Rdb Product Development Strategy High-end OLTP systems focus High performance Unique scalability on OpenVMS Extensive tuning capabilities High availability Robust on-line management Integration with Oracle software environment Oracle Developer Suite Oracle Application Server Oracle Enterprise Manager Oracle Database OpenVMS is the Operating System There are lots of different kinds of uses for Rdb: High-end, mission critical systems Departmental systems Small, desktop applications created years ago that remain critical to business operations. Each of these customers demand the utmost in system stability and performance. We have consequently defined our strategy and focused our development energies upon making the best, highest-performance, highest availability database systems for OpenVMS.There are lots of different kinds of uses for Rdb: High-end, mission critical systems Departmental systems Small, desktop applications created years ago that remain critical to business operations. Each of these customers demand the utmost in system stability and performance. We have consequently defined our strategy and focused our development energies upon making the best, highest-performance, highest availability database systems for OpenVMS.

12. 12 Overview � Where Rdb Is Used Trading commodities, equities & futures: US, UK, Australia, Austria, Sweden, Spain, France, Greece, Italy, Switzerland, Hong Kong, Singapore, Korea & Germany Mobile phone systems: US, Japan, Hong Kong, UK, South Africa, Peru, Germany, Austria, Czech Republic, Denmark, France, Greece, Portugal and Switzerland Semiconductor manufacturing: Worldwide Lottery Systems: Europe, Canada, Australia, South America & US Automobile manufacturing: Volvo, Nissan, Toyota, Fiat � Short Messaging Service: Worldwide Mining: Europe, Australia, US Passport control: New Zealand Government: Ireland, Department of Social, Community and Family Affairs Education: Europe, US, Australia -largest secondary system in Southern Hemisphere Smashing Atoms: SLAC Satellite Control/Communication: Worldwide Reservation systems: Thrifty and Dollar car rental Satellite Television: US Automatic Toll Systems: US It�s important for our customers to understand that Rdb is widely used in the world�s most mission critical systems. The smooth operation of more than half of the world�s cellular telephones and many, many financial institutions and trading organizations require Rdb. We understand that with this much critical dependence upon Rdb, Oracle must continue to meet the needs of our customers for a very high-performance, very stable system. Point out a few of your favourite customers. Intel is a good one in that the manufacture of ALL Intel integrated circuits depends upon Rdb (DBMS actually).It�s important for our customers to understand that Rdb is widely used in the world�s most mission critical systems. The smooth operation of more than half of the world�s cellular telephones and many, many financial institutions and trading organizations require Rdb. We understand that with this much critical dependence upon Rdb, Oracle must continue to meet the needs of our customers for a very high-performance, very stable system. Point out a few of your favourite customers. Intel is a good one in that the manufacture of ALL Intel integrated circuits depends upon Rdb (DBMS actually).

13. 13 Recent Wins New Sales driven by applications Deutsche Borse & Accenture Shanghai Exchange OMX Technology Thailand Exchange Singapore Exchange & Hong Kong Exchange EssNet (Lottery Systems) Tattersall�s, many others LogicaCMG (Short Messaging Services) Mobile Phone customer in Ireland VCS Aktiengesellschaft BBC Radio Cogema 2 new nuclear energy processing plants New projects with existing customers including SIAER, Sharp, Fidelity Investments, etc Yes, Rdb is a mature product, but this merely means that it is very stable while achieving its objectives of very high performance and availability. Certain types customers in many industries value these capabilities of stability, power and availability so much that Rdb continues to be selected for the most mission critical applications. BrokerTec is a company formed as a subsidiary of many banks around the world and it was formed to create a new securities exchange. Although there are many similarities between BrokerTec and the International Stock Exchange, they are separate and independent exchanges both starting operations in New York in mid-2000.Yes, Rdb is a mature product, but this merely means that it is very stable while achieving its objectives of very high performance and availability. Certain types customers in many industries value these capabilities of stability, power and availability so much that Rdb continues to be selected for the most mission critical applications. BrokerTec is a company formed as a subsidiary of many banks around the world and it was formed to create a new securities exchange. Although there are many similarities between BrokerTec and the International Stock Exchange, they are separate and independent exchanges both starting operations in New York in mid-2000.

14. 14 Rdb 7.2 Product Family on IA64 Rdb DBMS CDD Oracle Trace Replication Option SQS/OCIS JDBC Anything that you think of with the supported oracle rdb �product family� is available on I64 with the Rdb 72 family product release. The works � two database engines (rdb � the relational engine and dbms � the codasyl database engine), the common data dictionary, oracle trace (previously known as DECtrace), the replication option (ROR aka DDAL), the oracle sql services, odbc drivers and the native jdbc drivers. Etc. This includes all of the compiler interfaces.Anything that you think of with the supported oracle rdb �product family� is available on I64 with the Rdb 72 family product release. The works � two database engines (rdb � the relational engine and dbms � the codasyl database engine), the common data dictionary, oracle trace (previously known as DECtrace), the replication option (ROR aka DDAL), the oracle sql services, odbc drivers and the native jdbc drivers. Etc. This includes all of the compiler interfaces.

15. 15 Press Release, March 7, 2006 Oracle Rdb shipped production in January of 2006. And, due to the reality of the marketing world, we delayed our official announcement so as not to upstage the CEOs ?. Shortly after the joint oracle-hp-intel web broadcast event, oracle delivered our press release announcing the production release of Rdb V7.2 on I64 and Alpha.Oracle Rdb shipped production in January of 2006. And, due to the reality of the marketing world, we delayed our official announcement so as not to upstage the CEOs ?. Shortly after the joint oracle-hp-intel web broadcast event, oracle delivered our press release announcing the production release of Rdb V7.2 on I64 and Alpha.

16. 16 Rdb 7.2 Features Overview Increased Maximums �Number of database global buffers to 1,048,576 �Database page to 63 blocks, buffer size to 128 blocks Index column group enabled by default Refined index estimation enabled by default Index node pre-fetch performance optimizations Transaction rollback performance optimizations Caching of AIP entry information Improved backup IO performance Encrypted database & after-image journal backups for protection of confidential data This is a brief overview of the Rdb 72 new features. Visit the release notes for much more detail. The primary motivation and effort for Rdb 72 was in porting to I64. It was a large job involving many languages, several products, a large build and test environment, a field test and so on. But a number of customer-driven enhancements were also implemented. Among these are a number of performance enhancements (that will, in some cases, cut IO operation counts in half) and also a very popular addition of built-in encryption for database backups. Increasing the various database maximums for IO and buffer sizes and counts allows much more of the database to be cached in global buffers and can (drastically) reduce IO counts for some operations (since Ios can be twice as large). Various performance features are now enabled by default.This is a brief overview of the Rdb 72 new features. Visit the release notes for much more detail. The primary motivation and effort for Rdb 72 was in porting to I64. It was a large job involving many languages, several products, a large build and test environment, a field test and so on. But a number of customer-driven enhancements were also implemented. Among these are a number of performance enhancements (that will, in some cases, cut IO operation counts in half) and also a very popular addition of built-in encryption for database backups. Increasing the various database maximums for IO and buffer sizes and counts allows much more of the database to be cached in global buffers and can (drastically) reduce IO counts for some operations (since Ios can be twice as large). Various performance features are now enabled by default.

17. 17 Porting Rdb Applications to I64 Expect your application to be �Compile & Go� Likely visit build procedures Command line switches Alpha/VAX choices In the rare case they�re required, most changes end up being �one liners� Our experience to date is that the applications we�ve seen are nearly entirely �compile, link and run� on I64. The standard commercial application (user mode and nothing fancy) just work. The porting is, it appears, anti-climatic. Most of the stories we�ve heard from our customers and partners indicate that the command procedures used in the build procedures required the code changes � the programs didn�t!Our experience to date is that the applications we�ve seen are nearly entirely �compile, link and run� on I64. The standard commercial application (user mode and nothing fancy) just work. The porting is, it appears, anti-climatic. Most of the stories we�ve heard from our customers and partners indicate that the command procedures used in the build procedures required the code changes � the programs didn�t!

18. 18 Database Convert Paths Databases may be converted directly from Rdb 70 or 71 format to Rdb 72 format. An existing database or backup from VAX or Alpha may be converted or restored on a system (alpha or I64) running Rdb 72. For those databases older than V7.0, the conversion ends up being a two-step process. First convert to restore to Rdb 7.0 or 7.1 and then convert or restore to Rdb 7.2 format. The actual in-place database conversion to Rdb 7.2 format using the RMU/CONVERT utility generally takes some seconds. Of course, Oracle does suggest that you backup the database both before and after the convert. When upgrading an existing system to Rdb 72, there is no need to recompile or relink applications.Databases may be converted directly from Rdb 70 or 71 format to Rdb 72 format. An existing database or backup from VAX or Alpha may be converted or restored on a system (alpha or I64) running Rdb 72. For those databases older than V7.0, the conversion ends up being a two-step process. First convert to restore to Rdb 7.0 or 7.1 and then convert or restore to Rdb 7.2 format. The actual in-place database conversion to Rdb 7.2 format using the RMU/CONVERT utility generally takes some seconds. Of course, Oracle does suggest that you backup the database both before and after the convert. When upgrading an existing system to Rdb 72, there is no need to recompile or relink applications.

19. 19 Clustering Rdb 7.2 Database As has been the case for many, many years, Oracle Rdb continues to fully support and take advantage of VMS�s clustering capabilities. Clusters of Alpha and I64 systems in any combination may directly and simultaneously access an Rdb V7.2 format database. Among other things, this allows parts of the application to remain on Alpha while other parts have been migrated to I64. No need to �bet the bank� on an �all-or-nothing� single-day migration.As has been the case for many, many years, Oracle Rdb continues to fully support and take advantage of VMS�s clustering capabilities. Clusters of Alpha and I64 systems in any combination may directly and simultaneously access an Rdb V7.2 format database. Among other things, this allows parts of the application to remain on Alpha while other parts have been migrated to I64. No need to �bet the bank� on an �all-or-nothing� single-day migration.

20. 20 Remote Network Access to Rdb 7.2 Database In addition to cluster-wide access, Rdb includes a built-in network server capability. Using TCPIP or DECnet, applications anywhere on the network can access an Rdb 7.2 database as though it were local to the system. So in the case of, for example, an existing VAX-based application using Rdb that can not, for whatever reason, be ported to I64, the application can continue to run, unchanged, using Rdb 7.2 via Alpha or I64.In addition to cluster-wide access, Rdb includes a built-in network server capability. Using TCPIP or DECnet, applications anywhere on the network can access an Rdb 7.2 database as though it were local to the system. So in the case of, for example, an existing VAX-based application using Rdb that can not, for whatever reason, be ported to I64, the application can continue to run, unchanged, using Rdb 7.2 via Alpha or I64.

21. 21 Remote Network Access toOlder Rdb Database In addition to cluster-wide access, Rdb includes a built-in network server capability. Using TCPIP or DECnet, applications based on and built with Rdb 7.2 on Alpha or I64 can access existing Alpha or VAX-based databases. This again allows quite a bit of flexibility when moving large, complex environments into the present day. In addition to cluster-wide access, Rdb includes a built-in network server capability. Using TCPIP or DECnet, applications based on and built with Rdb 7.2 on Alpha or I64 can access existing Alpha or VAX-based databases. This again allows quite a bit of flexibility when moving large, complex environments into the present day.

22. 22

23. 23 Sort 100,000,000 recordsrx4640 vs. GS1280 A non-Rdb example of a performance test of Alpha vs. I64. SORT of a 100,000,000 record file. This is both CPU and IO intensive operation. Note that when using hypersort, the CPU time is *higher* than the elapsed time. This is due to hyper-sort being a multi-threaded application and multiple CPUs work together.A non-Rdb example of a performance test of Alpha vs. I64. SORT of a 100,000,000 record file. This is both CPU and IO intensive operation. Note that when using hypersort, the CPU time is *higher* than the elapsed time. This is due to hyper-sort being a multi-threaded application and multiple CPUs work together.

24. 24 Create Large Database8,151 Storage Areas Creating a very large and very complex database. The obvious improvements in Rdb 7.2 vs. 7.2 are due mostly to larger and more efficient IO operations. And note that I64 is faster than Alpha.Creating a very large and very complex database. The obvious improvements in Rdb 7.2 vs. 7.2 are due mostly to larger and more efficient IO operations. And note that I64 is faster than Alpha.

25. 25 Customer�s Application Testing Customer in italy ported to I64. In nearly every read-world test that they did, I64 is faster than Alpha and in some cases quite a bit faster.Customer in italy ported to I64. In nearly every read-world test that they did, I64 is faster than Alpha and in some cases quite a bit faster.

26. 26 ES45 vs. rx464030 Process OLTP Workload In April of 2005, we did some joint oracle-hp performance analysis of Rdb applications. Even at that very early stage, we can see I64 and Alpha performance basically equal between similar machine configurations. But the dollars per transaction is about 20% of the Alpha. I.E., the I64 system does the work for a fraction of the cost.In April of 2005, we did some joint oracle-hp performance analysis of Rdb applications. Even at that very early stage, we can see I64 and Alpha performance basically equal between similar machine configurations. But the dollars per transaction is about 20% of the Alpha. I.E., the I64 system does the work for a fraction of the cost.

27. 27 Rdb on I64 Summary Rdb on Alpha & I64 well tested & stable Migrating to Integrity is easy Alpha & I64 Clustering Rdb 7.2 performance improvements Performance & Cost/Performance on Integrity is excellent

28. 28 Oracle Rdb Roadmap

29. 29 7.2.1 Feature Overview(Scheduled Q1CY07) Compression for RMU/UNLOAD & LOAD Vastly improved compression for RMU/BACKUP Further improved IO behaviour for RMU/BACKUP, RMU/COPY & RMU/MOVE SQL Language enhancements Run-time durations captured more precisely IO, lock & transaction durations

30. 30 Future Project Areas Overview Development driven by customer needs! Encryption in database ODBC JDBC .NET SQL Service/OCI Services HP/UX client SQL Enhancements including addition PL/SQL support Savepoints Lobs Performance

31. 31 Rdb Lifetime Support Dates

32. 32 Training Partner List Europe, Asia, Middle East & Africa: VX Company Laren, The Netherlands http://www.vxcompany.com/rdbtrainingcourses Americas: JCC Consulting, Inc.  Granville, Ohio, United States  http://www.jcc.com/ (choose Training) Oracle CODASYL DBMS Training Worldwide: Software Concepts International Nashua, New Hampshire, United States http://www.sciinc.com/training/index.htm

33. 33 Summary After more than 12 years with Oracle, Rdb development continues because Rdb business is healthy & valuable Cooperation between Oracle & HP means better performance & manageability for our customers Development strategy maximizes value of Rdb investment

34. 34

35. 35