1 / 34

Maximizing Oracle Database 10g Efficiency on Windows Platform

Explore Oracle Database 10g features on Windows, self-managing capabilities, Flashback protection, ASM mirroring, and more. Enhance performance and reliability with Oracle Grid Computing solutions.

revilla
Download Presentation

Maximizing Oracle Database 10g Efficiency on Windows Platform

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The following 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 decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  2. Deploying Oracle Database 10gon the Windows Platform Mark Townsend Senior Director, Database Product Management Oracle Corporation

  3. Agenda • Today’s IT Infrastructure • Oracle Database 10g Solutions on Windows • Product Demonstrations • Commitment to Windows and .NET • Windows and .NET Customers • Q&A

  4. Today’s IT Infrastructure • Configured for peak loads • Limited scalability • Availability < 99.x% • Fragmented security

  5. Oracle Grid Computing Standardize, Consolidate, Automate • Storage • Database Servers • Application Servers • Management Tools

  6. Automatic Storage Management • Improved ease-of-use and configuration • Enhanced data provisioning • Support transportable tablespaces • Enhanced storage virtualization • Support multiple databases in a cluster • Support databases at multiple release levels

  7. Flashback Human Error Protection Flash Recovery Area Corruption Protection ASM Mirroring Storage Failure Protection Highest Data Protection at Lowest Cost Data Guard Site Failure Protection

  8. Oracle Real Application Clusters • Improved Robustness • Cluster Verification Utility • Improved OCR, Voting Disk resilience • Clusterware API for integrated application availability • Run-time load balancing • Certified to 100 nodes • Improved performance ERP CRM DW

  9. OracleDatabase 10g Self-Managing Database Automatic Performance Diagnostics & Tuning Automatic Space & Memory Management Self-Managing Backups Enterprise Configuration Management

  10. Service and System Management • Service • Any end-user business function • System • Key components responsible for supporting a service • Topological Views • Visual modeling • Relationships • Component level status • Dashboards • At-a-glance monitoring of all critical indicators Service Topology Service Dashboard

  11. Oracle Enterprise Manager 10g Plug-Ins for Windows • .NET Framework • SQL Server • ISA Server • BizTalk Server • Commerce Server • Active Directory • Internet Information Server

  12. Christian Shay Principal Product Manager .NET and Windows Oracle Corporation

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

  14. Oracle on .NET • Easy to use • Fully compliant with ADO.NET • Tightly integrated with Visual Studio • High performance • Fast out-of-the-box ADO.NET provider • Lots of tuning options • Advanced functionality • Oracle DB features exposed in .NET • RAC, XML DB, advanced security, etc.

  15. ODP.NET • Available today in production for free • http://otn.oracle.com/dotnet • Can be used with Oracle8, Oracle8i, Oracle9i, and Oracle10g database servers • DB server can be on Unix, Linux, Windows, etc. • Supports VS.NET 2002 and 2003 • VS 2005 (beta) • Supports .NET Framework 1.0 and 1.1 • .NET 2.0 (beta)

  16. ODP.NET Feature Highlights • Conforms to ADO.NET 2.0 spec • e.g. Factory Classes • Objects/UDTs • Database Change Notification • XML DB • Ref Cursors • LOBs • RAC/Grid • Works transparently with NO application changes

  17. ODP.NET – Optimized for Grid • Works transparently with NO application changes • When a node fails • Instant failover notification • Automatic connection cleanup • Automatic rebalancing • When a node is added • Automatic rebalancing • Ongoing workloads • Connections are dispensed based on load metrics

  18. Load Balancing Connection Request ODP.NET Conn. Pool “I am very busy” “I am busy” 10% idle 20% idle “I am bored” 70% idle

  19. Oracle Developer Tools for Visual Studio .NET • Free download • http://otn.oracle.com/dotnet • Tightly integrated “Add-in” for Visual Studio • Oracle is a premier-level partner in the Microsoft Visual Studio Industry Partner (VSIP) Program

  20. ODT Feature Overview • Oracle Explorer – browse and alter schema • Wizards and Designers • Automatic code generation • PL/SQL Editor/Debugger with IntelliSense • Oracle Data Window • Oracle Query Window (ad hoc SQL) • .NET Stored Procedure Deployment Wizard • Integrated help system – SQL, PL/SQL keywords

  21. ODT New Features • PL/SQL Debugging • Visual Studio .NET 2005 support

  22. Write .NET Stored Procedures for Oracle Oracle Developer Tools for VS.NET Client Application Visual Studio Environment Develop Invoke C#,VB.NET,C++ Server Project (Use ODP.NET if required) Stored Procedure, SQL .. Invoke Deploy Build Assembly foo.dll (proc sp) Oracle DB Extensions for .NET Stored Proc

  23. D E M O N S T R A T I O N Oracle Developer Tools

  24. Oracle Database 10g Express Edition • Small-footprint starter database • Free to • Download • Develop • Deploy • Distribute • Free online community forum

  25. Oracle Application Express 2.0 • Quick assembly of reporting and data entry applications • No programming or scripting • Instant deployment on the Web • Use the full power of Oracle Database 10g

  26. D E M O N S T R A T I O N Oracle Database 10g Express Edition

  27. Oracle’s Commitment to Windows Windows Management Plug-Ins 7 1993 2000 2001 2003 2004 2005 2006 Windows Server 2003 WindowsNT Windows2000 Windows XP Windows x64

  28. Oracle RAC on Windows Customers • Nextel • Mission-critical applications • US Army Medical Research (MRMC) • Consolidated evaluation/reporting system • WeightWatchers.com • Global web site • First Command Financial Planning • Financial services • Lex Vehicle Leasing • Global online rental application

  29. Oracle’s Commitment to .NET Oracle Data Provider for .NET(ODP.NET) ODP.NET Oracle Developer Tools for VS.NET Oracle Database Extensions for .NET Oracle Database 10g Express Edition 2002 2003 2005 2004 2006 .NET Framework 1.0 .NET Framework 1.1 .NET Framework 2.0

  30. Oracle .NET Customers • Thomson Financial • Financial information research • Ohio Savings Bank • Customer Call Center & Mortgage processing • Dell Corporation • Order Management • Credit Suisse First Boston • Mission critical system spanning three locations • Ziraat Bank • Core banking application on grid computing

  31. In Conclusion • The latest Oracle technology further empowers .NET and Windows developers • Oracle’s new management plug-ins deliver rich monitoring and management for Windows • Oracle Database 10g delivers the highest quality of service on Windows at the lowest cost

  32. Next Steps • Visit Oracle at booth # 800 - Hands-On Lab: Install Oracle Database XE - Daily Raffle: Win a pass to Oracle OpenWorld - Live product demonstrations - Oracle Windows and .NET experts • Download Oracle for Windows and .NET - oracle.com/technology/dotnet - oracle.com/technology/windows

  33. Q & Q U E S T I O N S A N S W E R S A

More Related