1 / 44

Oracle Database 10g Release 2

Oracle Database 10g Release 2. “Sophisticated Simplicity.”. Sean McCown, Infoworld . Source: http://www.infoworld.com/article/04/03/19/12TCoracle_1.html. Oracle Database 10g: Industry Awards. eWeek Analyst Choice Award. I.E. Readers’ Choice Award: Best DBMS for Data Warehousing.

gillespie
Download Presentation

Oracle Database 10g Release 2

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. Oracle Database 10g Release 2

  2. “Sophisticated Simplicity.” • Sean McCown, Infoworld Source: http://www.infoworld.com/article/04/03/19/12TCoracle_1.html

  3. Oracle Database 10g: Industry Awards • eWeek Analyst Choice Award • I.E. Readers’ Choice Award: Best DBMS for Data Warehousing • Voted # 1 for Databases

  4. “Simply put, Oracle 10g is by far the most sophisticated database on the market today” • Mario Morejon,CRN Source: http://crn.com/sections/software/software.jhtml?articleId=51200908

  5. Creation & Configuration 12 % Business Challenge – How to Scale DBA’s to the Grid ? Installation 6% Others 15% DataLoading 6% Software Maintenance 6% Ongoing System Management 55% Source: IOUG 2001 DBA Survey

  6. Oracle Database 10g: Easiest To Manage • 46% less DBA time than DB2 UDB 8.2 • 30% less DBA time than Microsoft SQL Server • Saves up to $50,000 per year per DBA Source: The Edison Group

  7. #1 for OLTP Performance Oracle Database 10g Enterprise Edition • #1 tpc-C on Linux 16 x 4-proc cluster • #1 tpc-C on Linux 32-proc Oracle Database 10g Standard Edition • #1 tpc-C on Linux 4-proc Oracle Database 10g Standard Edition One • #1 tpcC on 2-proc linux Source: www.tpc.org

  8. Proven OLTP Performance for both Clustered and SMP Environments $8.33/tpmC $5.52/tpmC 16X4 1X64 Source: www.tpc.org

  9. No No No No No No No No SAP World Records SAP Benchmark Category Current Benchmark Record Holder Oracle IBM Microsoft SD 3-tier SD Parallel ATO 2-tier ATO 3-tier Source: http://www.sap.com/benchmark/

  10. “Large operations will definitely find reasons to upgrade, and small shops stand to benefit from 10g, too. ” • Sean McCown, InfoWeek Review Source: http://www.infoworld.com/article/04/03/19/12TCoracle_1.html

  11. Market Leading VLDB Performance RAC SMP RAC Source: www.tpc.org

  12. Oracle Database 10g:Example Production Customers • Environmental Protection Agency • Public Internet access to environmental data • Leverages 10g Spatial • Credit Suisse First Boston • Mission Critical system spanning three locations • Leverages 10g RAC on Linux, DataGuard, Streams, XML DB • Talk America • Lead generation application • Informix migration, using 10g RAC and ASM • Chicago Stock Exchange • Third most active stock exchange in terms of share and volume • Leverages 10g Database with RAC, Application Server 10g • Dell Corporation • GEDIS – 6 Node EMEA Sales Order Entry with 6000 concurrent users on 10g RAC on Linux, ASM • Eurostar – 3 Node 1TB Datamart with 10g RAC on Linux, ASM, Grid Control

  13. ADT Security Services, Inc. Alliance Data Systems Application Security, Inc. BEI British Telecom Cadmus Speciality Publications CERN Chicago Mercantile Exchange Chicago Stock Exchange Cisco Inc CooperNeff CSFB DAB Bank Oracle Database 10g: Production Customers at OracleWorld • Dell (Eurostar and Gedis) • Dept. of Defense • Deutsche Post • eBay • Emirates Airline • EPA • Etagon • Fannie Mae • Fichtner Consulting & IT (German Rail) • First American Real Estate Solutions • Hotsos Enterprises, Ltd. • Humana • Jobnet • Ken Rob and Associates (FAA) • Lansing Community College • Legislative Assembly of Ontario • Lunartek (British Columbia Corporate Registry) • Motorola Corporation • Motorola, Inc. • Nationwide Insurance • newscast • Ohio Savings Bank • Pepsico • Precision Response Corp. • Prolexys • Qualcomm • Red Sky Data • Reserve America • Rightsizing, Inc • Roman Inc. • Seertech Solutions • Softbank • Sprint Corporation • Starwood Hotels & Resorts Worldwide • Systems Plus • Talk America • Telstra • The Pythian Group • TLQ Consulting • U.S. Geological Survey • University of Oklahoma • University of Oslo • University of Wolverhampton • Vanderbuilt University • Verizon Information Services

  14. Oracle Database 10g Release 2

  15. Oracle Database 10g Release 2 - Goals • Deliver a timely release for installed base upgrade • Announcement at OW in December • Hosted Beta started October, Beta started January • RTM by end of 1H CY2005 • Deliver a high-quality, stable release • Deliver key new features to the market

  16. Application Server Grid Storage Grid Database Grid Grid Control Recap - Original Oracle Database 10g Goals • Highest Quality of Service • Lowest Cost • Easiest to Manage

  17. Automatic Storage Management • Automatic I/O load balancing • Stripes data across disks to balance load • Best I/O throughput • Automatic mirroring • Eliminates need for conventional file system and volume manager • Capacity on demand • Add/drop disks online • Easy Automatic Storage Management

  18. Oracle Database 10g Release 2 - 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 • Oracle Cluster File System for Solaris Automatic Storage Management

  19. Unbreakable Low Cost Storage • ATA storage arrays • Low Cost • Unbreakable Availability • Unlimited Scalability • Unbreakable Low Cost Storage Program • Validates low cost storage configurations • Partnership with leading storage vendors

  20. Oracle for Business ILM • Oracle has unique capabilities that make it ideal for business ILM • Fine grained ILM • Oracle manages the lifecycle of groups of business data down to the level of individual rows • Application Transparent ILM • Oracle classifies business data transparently to the application • Low Cost ILM • Oracle can use low cost storage to greatly reduce the cost of retaining data Partitioning High Performance Storage Tier Low Cost Storage Tier Historical Storage Tier Active Recent orders Less Active This years orders Historical Last 5 years orders

  21. Data Guard Site Protection Flashback Human Error Protection Flash Recovery Corruption Protection ASMMirroring StorageProtection Storage Grid - Highest Data Protection for Lowest Cost

  22. Oracle Backup – Low Cost Tape Backup ASM, Database Files, Recovery Areas and OS Files • Low cost alternative to complex backup products • Best integrated end-to-end backup of Oracle Databases • Scalable to low 100’s of servers, 10’s of millions of files • Bundled with Oracle Database - Single vendor support OracleBackup Performant, Low CostTape Backup

  23. Oracle Database 10g Release 2 - Fault Tolerant Standby Physical or Logical Standby DB Production Database Automatic Failover Synchronous Log Shipping • Fast-Start Failover implements automatic failover to a standby database • Triggered by failure of Site, Hosts, Storage, or Network • Works with and supplements RAC server failover • Failover occurs in seconds • Original production site automatically rejoins the configuration after recovery

  24. Oracle Database 10g Release 2 – Improved Security Application • Transparent Data Encryption • Includes Key Management • Transparent to applications • Helps Address Privacy and Regulatory compliance • Store Username and Password in Wallet • Protect username and password on command line for batch jobs • SmartCard integration for SSL • Support existing certificates on smartcards ASO Network Encryption Data Decrypted Through SQL Interface Data Written To Disk Encrypted Data Encrypted On Backup Files

  25. Single Platform for All Your Data Oracle Collaboration SuiteUnified Messaging and Files • Complete • Integrated • Robust • Scalable • Secure • Available on all platforms Oracle Ultra SearchEnterprise Search Solution XML DBIntegrated Native XML Database Oracle Text Text Processing Engine Oracle Locator & SpatialLocation and Proximity Searching Oracle interMediaMultimedia management RelationalCharacters, Numbers, Dates, LOBs

  26. Complete Integrated Robust Scalable Secure Available on all platforms Enhanced LOB performance Online local partitioned text indexes DICOM and JAI 1.1.2 Support Improved performance of Network and Topology Models Western Europe routing and geocoding EPSG Coordinate Systems Georaster Compression Industry’s first XML Query Support Oracle Database 10g Release 2 –All Your Data

  27. Native XML Query support in the Database User • XML Query is emerging as the consensus query language for XML • Expected W3C Recommendation in late 2005 • First mainstream commercial database release to support XML Query • Native = Fast, Efficient • Can mix-and-match XML Query and SQL in same query XMLQuery SQLX XML DB

  28. Oracle Database 10g Release 2 - Data Provisioning • Online Transportable Tablespace • Full Database Transport Within Same Endian Platforms • Improved Oracle Streams Performance and Manageability • Tablespace Repository London San Francisco

  29. Database Server Grid –Real Application Clusters • Runs Real Applications • Runs on standard,low cost servers • Fault tolerant • Proven • Over 4500 customer sites ERP CRM DW

  30. Oracle Database 10g Release 2 – Real Application Clusters • Improved Robustness • Cluster Verification Utility • Improved OCR, Voting Disk resilience • Clusterware API for integrated application availability • Runtime load balancing • Certified to 100 nodes • Improved performance ERP CRM DW

  31. ERP CRM DW Oracle 10g Grid ManagementOne-half to one-tenth the cost • Self-Managing Database • OEM Grid Control • Grid-wide operations • Scale from one to hundreds of systems with little incremental cost

  32. Oracle Database 10g Release 2 – Self-managing Improvements • Enhanced Performance Self-Diagnostics • More powerful Automatic Database Diagnostic Monitor (ADDM) • Current Activity Performance Analysis • Automatic Workload Repository (AWR) Diff-Diff Reporting • Segment Advisor runs automatically during maintenance windows • Allow dropping of empty datafiles in tablespaces

  33. Oracle Database 10g Release 2 – Improved DB Control • New, Easier to Use Performance Screens • Support for Streams, AQ, XDB, and Spatial • SGA-attach mechanism for performance data • Enables analysis of slow or hung systems

  34. Oracle Database 10g Release 2 – Improved Job Scheduler • Job Chaining • Event Scheduling • Customized calendars

  35. System Topology Viewer Model applications, clusters, storage Leveraged by all Grid Control subsystems Services Dashboard Model business services Define and monitor SLA Adaptive Alert Threshold Oracle Database 10g Release 2 – Improved Grid Control

  36. Business Intelligence on the Grid • Lower Cost • Leverage hardware, software, labor savings • Manage millions of terabytes • Intelligence when you need it • Cross-platform transportable tablespaces • Asynchronous change data capture • More value from your data • Mature OLAP, Data Mining • Improved SQL Analytics – SQL Model Clause

  37. Oracle Database 10g Release 2 – Improved Data Warehousing • Performance • Up to 10x improvement in sort performance • Up to 3x improvement in aggregate performance • Partitioning • Increase maximum number of partitions per table from 64k to 512K • Support ‘multidimensional’ partition-pruning • Analytics • Support standard linear algebra libraries within PL/SQL • Enhancements to the SQL ‘model’ clause • Decision trees in Oracle Data Mining • ETL • DML Error-logging

  38. Improved User Interface • Improved Documentation and Online Help • Master Detail Wizard • Improved User Interface • Improved Documentation and Online Help • Master Detail Wizard • Charting Enhancements Oracle Database 10g Release 2 – HTML DB Release 2 • Improved User Interface • Improved User Interface • Improved Documentation and Online Help

  39. Oracle Database 10g Release 2 – .Net Development • Visual Studio Integration (delivery via OTN) • Callout to Common Language Runtime • ODP.Net Fast Connection Failover

  40. Oracle Database 10g Release 2 – Other Application Development • Client notification on table update • Linux ODBC Driver • JDBC 3.0 support, run-time load balancing, XA Connection Caching • SQL Regular Expressions - support for key Perl conventions • Unicode 4.0 Support • PL/SQL Compilation Versioning

  41. ERP CRM DW Oracle Database 10g Release 2 - Summary • Lowest Cost • Oracle Backup • Improved Sort • Streams Performance • Clusterware API • Highest Quality of Service • Rolling Upgrades • Fast-Start Failover • Transparent Data Encryption • Easier to Manage

  42. Where to go for further Information

More Related