Transcript Jerry Held - GCOUG - Greater Cincinnati Oracle Users Group

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
 Voted # 1 for Databases
“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
Business Challenge –
How to Scale DBA’s to the
Grid ?
Installation
6%
Creation &
Configuration 12 %
Others
15%
Software
Maintenance 6%
Data
Loading 6%
Ongoing System
Management 55%
Source: IOUG 2001 DBA Survey
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
#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
Proven OLTP Performance for both
Clustered and SMP Environments
Transaction Processing Council
TPC-C Performance
tpmC
1,200,000
1,000,000
800,000
600,000
$8.33/tpmC
$5.52/tpmC
400,000
200,000
0
Source: www.tpc.org
RAC
SMP
16X4
1X64
SAP World Records
SAP Benchmark
Category
SD 3-tier
SD Parallel
ATO 2-tier
ATO 3-tier
Source: http://www.sap.com/benchmark/
Current Benchmark Record Holder
Oracle




IBM
Microsoft
No
No
No
No
No
No
No
No
“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
Market Leading VLDB Performance
Transaction Processing Council
Terabyte Scale TPC-H Performance
90,000
QphH
75,000
60,000
45,000
Oracle
30,000
15,000
0
Source: www.tpc.org
1Tb
3Tb
10Tb
RAC
SMP
RAC
Oracle Database 10g:
Example Production Customers

Environmental Protection Agency
–
–

Credit Suisse First Boston
–
–

–
Lead generation application
Informix migration, using 10g RAC and ASM
Chicago Stock Exchange
–
–

Mission Critical system spanning three locations
Leverages 10g RAC on Linux, DataGuard, Streams, XML DB
Talk America
–

Public Internet access to environmental data
Leverages 10g Spatial
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
Oracle Database 10g: Production
Customers at OracleWorld













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














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
Oracle Database 10g
Release 2
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
Recap - Original Oracle
Database 10g Goals
Storage Grid
Database Grid
Application Server
Grid
Grid
Control
 Highest Quality of Service
 Lowest Cost
 Easiest to Manage
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
–
Automatic Storage
Management
Add/drop disks online
 Easy
Oracle Database 10g Release 2 Automatic Storage Management
 Improved ease-of-use and
configuration
 Enhanced data
provisioning
–
Support transportable
tablespaces
 Enhanced storage
virtualization
–
–
Automatic Storage
Management
Support multiple
databases in a cluster
Support databases at
multiple release levels
 Oracle Cluster File System
for Solaris
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
Oracle for Business ILM


Oracle has unique capabilities that
make it ideal for business ILM
Fine grained ILM
–
Partitioning

Application Transparent ILM
–

High
Low Cost
Performance Storage Tier
Storage Tier
Historical
Storage Tier
Active
Less Active
Historical
Recent
orders
This years
orders
Last 5 years
orders
Oracle manages the lifecycle of
groups of business data down
to the level of individual rows
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
Storage Grid - Highest Data
Protection for
Lowest Cost
Data Guard
Flashback
Flash
Recovery
ASM
Mirroring
Storage
Protection
Corruption
Protection
Human Error
Protection
Site
Protection
Oracle Backup – Low Cost
Tape Backup
Oracle
Backup
ASM,
Database
Files,
Recovery
Areas and
OS Files
Performant,
Low Cost
Tape
Backup
 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
Oracle Database 10g Release 2 Fault Tolerant Standby
Production
Database
Automatic Failover
Physical
or Logical
Standby DB
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
Oracle Database 10g Release 2 –
Improved Security
 Transparent Data Encryption
Application
ASO
Network
Encryption
Data
Decrypted
Through
SQL Interface
Data
Written
To Disk
Encrypted
–
–
–
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
Data Encrypted
On Backup Files
–
Support existing
certificates on smartcards
Single Platform for All Your
Data
Oracle Collaboration Suite
Unified Messaging and Files






Complete
Integrated
Robust
Scalable
Secure
Available on all
platforms
Oracle Ultra Search
Enterprise Search Solution
XML DB
Integrated Native XML Database
Oracle Text
Text Processing Engine
Oracle Locator & Spatial
Location and Proximity Searching
Oracle interMedia
Multimedia management
Relational
Characters, Numbers, Dates, LOBs
Oracle Database 10g Release 2 –
All Your Data






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
Native XML Query support in
the Database
User
 XML Query is emerging as
the consensus query
language for XML
 First mainstream
commercial database
release to support XML
Query
–
Native = Fast, Efficient
 Can mix-and-match XML
Query and SQL in same
query
XML DB
SQLX
Expected W3C
Recommendation in late
2005
XML
Query
–
Oracle Database 10g Release 2 Data Provisioning
London
 Online Transportable
Tablespace
San Francisco  Full Database
Transport Within Same
Endian Platforms
 Improved Oracle
Streams Performance
and Manageability
 Tablespace Repository
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
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
Oracle 10g Grid Management
One-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
ERP
CRM
DW
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
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
Oracle Database 10g Release 2 –
Improved Job Scheduler
 Job Chaining
 Event Scheduling
 Customized calendars
Oracle Database 10g Release 2 –
Improved Grid Control
 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
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
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
Oracle Database 10g Release 2 –
HTML DB Release 2
 Improved User
Interface
 Improved
Documentation and
Online Help
 Master Detail Wizard
 Charting
Enhancements
Oracle Database 10g Release 2 –
.Net Development
 Visual Studio
Integration (delivery
via OTN)
 Callout to Common
Language Runtime
 ODP.Net Fast
Connection Failover
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
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
ERP
CRM
DW
Where to go for further
Information