Insert Picture Here Oracle Database 11 g for

<Insert Picture Here> Oracle Database 11 g for Windows and. NET Alex Keh Principal Product Manager, Server Technologies

Agenda • Oracle Database 11 g on Windows • • • Oracle for. NET Developers • • • Oracle Database – Best Performance Windows OS Integration Ease of Development Performance Manageability and Installation Unified Oracle and Microsoft Server Management Oracle Fusion Middleware Next Steps

<Insert Picture Here> Oracle Database 11 g on Windows

Oracle Database 11 g Value Proposition • • Easiest to Manage Highest Quality of Service • • • Highest Performance and Scalability Fault Tolerant Most Secure Best Information Lowest Cost Lowest Risk of Change

Oracle Database 11 g - Performance Database Resident Connection Pool Java Just-In-Time Compiler Query Result Caching Client Side Caching Up to 20 x connections Up to 11 x Faster Up to 25% Faster Up to 22% Faster RAC Performance Enhancements Oracle Secure Backup Oracle Streams Enhancements Optimizer Stats Collection Up to 70% Faster Up to 25% Faster Up to 2 x Faster Up to 10 x Faster

Oracle Secure Files Breaking the Performance Barrier… Secure Files Linux Files File Size (Mb) Write Performance Mb/Sec Read Performance Secure Files Linux Files File Size (Mb)

New in Oracle Database 11 g Extended XML Support with Binary XML Performant Schema-based XML - Object Relational Unstructured XML - Binary XML - LOB Schema-less Flexible Structured

Best Price/Performance on Windows • #1 TPC-C Price/Performance amongst all platforms • Oracle Database 11 g on Windows TPC-C by Price/Performance Highest Ranking Benchmark 11 g SQL 2005 1 st 3 rd Price/tpm. C $0. 73 $0. 84 tpm. C 102, 454 82, 774 Publication Date 9/12/07 3/27/07 • …And Oracle has the #1 TPC-C Performance also As of 9/12/07: HP Pro. Liant ML 350 G 5, 102, 454 tpm. C, $. 73/tpm. C available 12/31/07. HP Integrity Superdome Server, 4, 092, 799 tpm. C, $2. 93 tpm. C, available 8/6/07 (#1 TPC-C performance). Source: Transaction Processing Performance Council (TPC) www. tpc. org

Windows Integration - Active Directory and Windows Security • Database Registration and Name Resolution • • Support authenticated connection to Active Directory using OS authentication Kerberos Authentication • • Stronger encryption algorithms (DES 3, AES, RC 4) • Support default encryption type supported by MS KDC Use DNS Domain Name as Kerberos REALM name by default Kerberos authentication to Oracle database in a MS crossdomain setup Removal of 30 character limit on the Kerberos user name

Direct NFS Client on Windows • Network Attached Storage (NAS) use Network File System (NFS) • Oracle Database 11 g allows direct Windows NFS v 3 access • Part of DB kernel in Oracle Disk Manager library • Benefits: easier manageability, simplified tuning, and better diagnostics • Common Oracle NFS interface for potentially all host platforms and NFS servers

<Insert Picture Here> Pricing and Packaging

Oracle Database Express Edition • Small-footprint starter database • Free to download, develop, deploy, distribute • Installs in about 10 minutes • Uses native Windows installer • Standard silent install method • Download size • Server (includes client) - 157 MB • Client - 30 MB • Quick start tutorials for DB and developer novices

Oracle Database Solutions That Grow with You Average Connected Users 10, 000 1, 000 400 Standard Edition One (2 sockets max) Enterprise Edition (Unlimited processors) Standard Edition (4 sockets max)

Where to Buy*…. CDW NUP Insight www. CDW. com/oracle SE 1 Dell www. dell. com/oracle 1 -800 -274 -3355 http: //www. insight. com Search on ‘Oracle’ Enterprise Edition Proc $3, 744 Call $3, 885 A 0188528 L 10312 $250 Call $233. 33 A 0041841 L 10004 $15, 000 Call $11, 666. 66 A 0052806 A 90610 $800 Call EDC 440259 NUP L 10314 EDC 440289 Proc A 0188526 EDC 440283 NUP $115 EDC 875678 Standard Edition Call EDC 560325 Proc $125 A 0053326 L 10001 $30, 804. 99 Call EDC 440465 A 0039545 A 90611 * LIST PRICES SHOWN WHERE AVAILABLE

<Insert Picture Here> . NET Development with Oracle Database

. NET Development Environment Oracle Providers for ASP. NET Oracle Developer Tools for VS Visual Studio Environment Develop C++, C#, VB. NET Application Deploy IIS MTS/ (ASP COM+ ASP. NET) Application Deploy IIS Database Development Oracle DB Extensions For. NET ODP. NET Oracle Services for MTS

Oracle Developer Tools for Visual Studio • Free • “Add-in” for Visual Studio 2005 and VS. NET 2003 • Easy to use and intuitive • Powerful features that enhance productivity • Fully integrated with Visual Studio • Easy ASP. NET web application development • Designers and wizards • Automatic. NET code generation • PL/SQL editor/debugger • Source Control Integration • Much more • Stay in Visual Studio for project lifecycle

Oracle Data Provider for. NET • Free • Easy to learn, even if new to Oracle • Compliant with ADO. NET 1. x, 2. 0, and higher • No learning curve • Complete access to. NET functionality • Native access to Oracle Database • Utilize advanced Oracle Database features • RAC, performance, security, data types, XML, etc. • Oracle Providers for ASP. NET use ODP. NET

Oracle Database Extensions for. NET (AKA. NET Stored Procedures) • Write Microsoft Visual C# or Visual Basic. NET procedures/functions • Oracle Database 10 g Release 2 or higher on Windows option • Build assembly in Visual Studio. NET • Deploy from Visual Studio. NET into Oracle using. NET Deployment Wizard

Develop on Windows, Database on any Platform ODT and ODP. NET Visual Studio Environment Windows Linux Unix Other Oracle 11 g, 10 g, 9 i, or 8 i

“ Oracle on. NET Customers We’re taking the best of both worlds –. NET and Oracle – to give us the best platform possible. ODP. NET is vital to the success of our next-generation application ” Bill Evjen, Technical Architect “ Since we use a Microsoft. NET middle tier, Oracle Data Provider for. NET provided the high throughput, high performance, and bulletproof connectivity to the database ” Jim Lombardi, Principal Database Engineer “ Integrating ODP. NET was easy and straightforward. . we were able to take advantage of… the power and high availability of the grid ” Jason Lin, Assistant Vice President, Application Integration and Architecture

New. NET Feature Themes • Ease of Development • • Performance • • • Tight integration with Visual Studio 2005 Web Application Development (ASP. NET) Objects Expose new tuning features Improve performance out of the box Manageability and Installation • Deployment: smaller client and easier packaging

<Insert Picture Here> Ease of Development

Visual Studio Integration – Oracle Developer Tools • Fully integrated with Visual Studio 2005 • Server Explorer • Data Sources Window • Data Source Configuration Wizard • Dataset Designer • Table. Adapter Configuration Wizard • Query Builder/Query Designer • More • Automatic code generation – Winform and ASP. NET • Data Sources Window • Integration with SQLData. Source control • Makes ASP. NET web application development very easy

Visual Studio Integration • New Oracle Database Project • Manage, Edit and Run SQL scripts • SQL*Plus is built in • Source control integration – Source. Safe and Team Foundation Server • Oracle Query Window • New UI • Explain Plan • Auto-commit toggle • ODT Options page • Customize how you use ODT

D E M O N S T R A T I O N New ODT Features

Web Application Development (ASP. NET) • ASP. NET Providers • • Pre-built services to store website state into databases Easy to learn • Based on standard ASP. NET provider APIs and schema Installation • Run PL/SQL scripts to create provider schemas Namespace • Oracle. Web

Web Application Development (ASP. NET) • Oracle Providers for ASP. NET Components • • • Cache Dependency Provider Membership Provider Profile Provider Role Provider Site Map Provider Session State Provider Web Parts Personalization Provider Web Event Provider Administrators can pick and choose which providers to use

D E M O N S T R A T I O N ASP. NET Providers

<Insert Picture Here> Performance

Performance – Data Retrieval • Data retrieval performance improvements (11 g) • • • Client Result Cache • Caches results sets either on client or server • Shared across sessions in the same process • Cache remains consistent via DB Change Notification Better LOB performance • LOB prefetching – fewer roundtrips Improved statement caching • Cache ODP. NET parameter contexts

Performance – 64 -bit • • Allow ODP. NET and. NET stored procedures to use more scalable 64 -bit hardware (10. 2. 0. 3) Windows x 64 • • • Windows Itanium • • • 64 -bit ODP. NET 64 -bit. NET Stored Procedures Available for download on OTN from. NET Center

<Insert Picture Here> Manageability and Installation

Installation – Simpler Deployment • Easier to package ODP. NET for large scale deployments • • • Smaller ODP. NET footprint • • • OUI install – small footprint Xcopy install – smallest footprint Faster ODP. NET deployment • • Xcopy – administrators script to specific requirements, generally large deployments OUI – for small scale deployments Xcopy No difference in ODP. NET functionality

Installation – Simpler Deployment • IC xcopy components • • • ODP. NET Oracle Providers for ASP. NET Oracle Provider for OLE DB OO 4 O Oracle Services for MTS IC deployment • • Via OUI - Use the installer as you normally would Via xcopy • Step 1: Copy IC files to disk • Step 2: Run install. bat • Step 3: Add installation directories to Windows PATH • Step 4: Modify NLS_LANG to desired locale

<Insert Picture Here> Unified Oracle and Microsoft Server Management

Grid Control for Microsoft Servers Systematic way to extend system coverage • Key Benefit: Centralize • • Management Enable GC to monitor and manage new components Windows Host Management MOM Connector Microsoft plug-ins: • • • Exchange SQL Server Active Directory. NET Framework IIS

<Insert Picture Here> Oracle Fusion Middleware on. NET

Oracle Fusion Middleware and. NET Bridging MS and non-MS Infrastructure with Enterprise Capabilities Msft Outlook M i c r o s o f t Msft Excel Msft Word IDE App/Services Msft SQL Server BPM BI Portal Service, Event Registry Apps – Oracle, Psft, JDE, SAP, Siebel, Legacy, etc. Msft. Net UI Msft Info. Path Sys. Mgmt Enterprise Service Bus Msft MSMQ Msft Servers i. e. Biz. Talk HA DBMS – Oracle, DB 2, Informix, etc. Sys Mgmt – HP, CA, IBM, BMC, etc. Security & ID Mgmt Oracle Fusion Middleware Msft Active Directory BI – Business Objects, Cognos, etc. J 2 EE – BEA, IBM, JBoss, etc. ID Mgmt – Sun, Novell Open. LDAP, etc. TP Monitors, Messaging – Tuxedo MQ, Sonic, CICS, IMS Tibco

<Insert Picture Here> Next Steps

More Information • OTN Windows Technology Center • http: //otn. oracle. com/windows • OTN. NET Developer Center • http: //otn. oracle. com/dotnet • . NET Blog • http: //cshay. blogspot. com/ • For more questions • alex. keh@oracle. com

More Information • OTN Fusion Middleware and Microsoft • http: //www. oracle. com/technology/products/mi ddleware/fusion-middleware-microsoftinteroperability. html • OTN Grid Control Plug-ins and Connectors • http: //www. oracle. com/technology/products/oe m/extensions

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and 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.