Oracle Database 10g Release 2
Oracle Database 10g
Awards
 eWeek Analyst Choice Award and Top 10
Product of 2004
 I.E. Readers’ Choice Award: Best DBMS
for Data Warehousing for last 7 of 8 years
 CRN recommends 5/5 stars
 DM Review 2005 Winner of Readers
Award for Database and Data Store
 InfoWorld “Database of the Year” 2004
 Java Developers Journal “Best Enterprise
Database” 2005
Oracle Runs Most of the
World’s Largest Databases
• The world’s largest commercial database runs Oracle
• 100 TB DW at Yahoo!
• The world’s largest commercial UNIX DW runs Oracle
• The world’s largest commercial Linux DW runs Oracle
• 24.7 TB DW at amazon.com (#6 biggest DW in world)
• Oracle powers nine of the world’s top 10 UNIX OLTP
systems
• 16 TB DB at US Patent Office is #1
Source: Winter Corporation, September 2005, http://wintercorp.com/VLDB/2005_TopTen_Survey/TopTenWinners_2005.asp
Number of RAC Customers
RAC Adoption Rate Growing…
6,000
5,000
4,000
3,000
2,000
1,000
0
FY02
FY03
Source: Oracle Internal Reporting, Q4-FY’05
FY04
FY05
Oracle #1 RDBMS Vendor on
Linux
Marketshare (%)
100%
29%
80%
17%
58%
60%
Other
40%
20%
69%
81%
39%
0%
2002
2003
Source: Gartner DataQuest May 2005, based on New Licenses Sales
2004
IBM
Oracle
Grid Computing For
All IT Resources
Applications
Information
Infrastructure
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
Talk America - Automatic
Storage Management
“Being a DBA myself, I
understand how much manual
labor is required in allocating and
managing storage space, and the
mistakes that could be
detrimental. ASM seamlessly
takes that away. It automates that
whole procedure.”
- Vishal Anand
Senior database project specialist and
administrator
Talk America
http://www.oracle.com/technology/oramag/oracle/05-mar/o25news.htmlMarch/April 2005
Oracle Database 10g Release 2 –
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
Oracle Clusterware
• Provides unified framework for managing applications
and database using the same HA infrastructure
Custom Application
Apache
Apache
listener
listener
listener
database
RAC db
RAC db
ORACLE_HOME
ORA_CRS_HOME
ORACLE_HOME
ORA_CRS_HOME
Microsoft IIS
Custom Application
ORACLE_HOME
ORA_CRS_HOME
ORA_CRS_HOME
DELL
Order Processing
• Challenges
• Old system was single instance 9i database with limited
scalability, Limited capacity for numbers of users required
in the future
• Solution
• 6 node Oracle Database10g Real Application Clusters with
Automatic Storage Management in production on Linux
since September 2004
• Results
• Achieved higher availability and scalability
• Achieved payback on investment in 12 months
• Expected Net savings of $4.6 million over five years
http://www.oracle.com/customers/studies/roi/dellgedis.pdf
New !
Oracle TimesTen
In-Memory Database
A new database for application-tier data management in
next-generation enterprise architectures
Presentation
Tier
IMDB Features
• Instant response
• High throughput
• Data replication
Real-Time Enterprise Applications Application
Tier
• Oracle data caching
• Standard APIs
Enterprise
Database
Tier
New !
TimesTen In-Memory Database
• RDBMS/SQL data model
Network
Application
TimesTen
libraries
...
• JDBC, ODBC APIs
• API for change notification
Application
TimesTen
libraries
• Application tier execution
• Embedded and C/S
ClientServer
In-Memory
Database(s)
Transaction Logs
Checkpoint Files
Application-Tier
Platform
• “Real-time” performance
• Low latency
• High throughput
•
•
•
•
Data persistence & recovery
Async & sync disk logging
Small footprint (6MB)
Near-zero administration
Oracle Database 10g - Highest
Data Protection at
Lowest Cost
Data Guard
Site Failure
Protection
Flashback
Flash
Recovery
Area
ASM Mirroring
Storage Failure
Protection
Corruption
Protection
Human Error
Protection
Oracle Database 10g Release 2 –
Fault Tolerant Standby
Automatic Failover
Production
Database
•
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
•
•
Physical
or Logical
Standby DB
Comparable to cluster failover
Original production site automatically rejoins the configuration
after recovery
Oracle Database 10g Release 2 –
Transparent Data Encryption
Application
ASO
Network
Encryption
Data
Decrypted
Through
SQL Interface
Data
Written
To Disk
Encrypted
Data Encrypted
On Backup Files
• Transparent Data
Encryption
• Includes Key
Management
• Transparent to
applications
• Helps Address Privacy
and Regulatory
compliance
Coming !
Oracle Secure Backup
• Oracle Secure Backup is a low cost
alternative to complex tape backup products
• Fastest & Best integrated backup for Oracle
Database
• Oracle9i and 10g database backup
using RMAN
• Easy management using Enterprise
Manager
• Encrypted backups
• Central Management of network backups
• Scales to low 100’s of servers
 Replaces Legato LSSV (LSM) bundle
Oracle 10g Grid Management
One-half to one-tenth the cost
•Self-Managing Database
•AWR
•ADDM
•SQL Tuning Advisor
•OEM Grid Control
•Grid-wide operations
•Scale from one to
hundreds of systems
with little incremental
cost
ERP
EMAIL
DW
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
Self-Managing Database
•
Automation of Routine Tasks
•
•
•
•
•
Built-in Intelligent Infrastructure
•
•
•
Code instrumentation
Workload repository
Tools to Empower the DBA
•
•
•
Automatic disk-based Backup and Recovery
Automatic optimizer statistics collection
Automatic Memory Management
Automatic Storage Management
Automatic Database Diagnostic Monitor
Automatic Tuning Optimizer
Lots more …
Starwoods - Pains and
Challenges
•
•
•
•
Very Diverse DBA Skills and Experience
Number, Size and Complexity of Databases on the Rise
DBA Team Remains the Same
Result - Senior DBAs are Overloaded
- Reactive Management, Hardly Proactive
- SQL Tuning Strains Resources Further
- Strategic Planning Difficult
"ADDM … can tell the DBA not only what happened and why,
but most important, what to do next.”
- Arup Nanda
Manager of Database Systems,
Starwood Hotels
http://www.oracle.com/technology/pub/articles/10gdba/week18_10gdba.html
Oracle Database 10g Release 2 –
Improved DB Control
• Single Instance to RAC
Conversion
• RAC Topology and
Interconnect Monitoring
• High Performance Change
Management Functionality
• Backup Reports
• Baselines
• New, Easier to Use
Performance Screens and
• SGA-attach mechanism
•
Enables analysis of slow or
hung systems
Automated Provisioning
Scale Out to More Systems and Minimal Incremental Cost
Oracle
Inventory
Software
Configurations
View/Search
Enterprise
Manager
Grid Control
Hardware
Configurations
Compare/Diff
Change Tracking
Reference
Configurations
Install/Clone
Oracle.com
Configure
Product Updates
Patch
Secure
Over 20% of downtime
attributable to human
configuration errors
Patches
Product
Configuration
Oracle OEM 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
• Patch Distribution and
Application
Oracle Database 10g Release 2 –
Improved Job Scheduler
Event
 Chaining
 Events
 Customized Calendars
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 –
Native XML Query
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 2006
XML
Query
•
Oracle Database 10g Release 2 –
Improved Data Warehousing
• Performance
• Up to 5x improvement in sort performance
• Up to 3x improvement in aggregate performance
• Partitioning
• Increase maximum number of partitions per table from 64k
to 1024K-1
• 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
QphH
TPC-H 300G
9,000
8,000
7,000
6,000
5,000
4,000
3,000
2,000
1,000
0
10.1
10.2
• 27% Improvement 10.2 over 10.1, same hardware
Source: tpc.org, 10.2 benchmark used PowerEdge 6600/3.0GHz/4MB w/Oracle DB 10g R2, availability date Jan 8th
2006. 10.1 benchmark used same hardware w/Oracle DB 10g R1, availability date Sept 10th 2004,
Complete Application
Development Support
Development Community
Oracle Provides
Compiled Languages - C and
C++, Cobol, etc
OCI and OCCI, PreCompilers
Windows/.Net
Visual Studio Add-In,
ODBC/ODP.Net Drivers, CLR
support in the Database
Java
JDeveloper, JDBC/SQLJ, Java
Support in the Database
PHP
ZendCore Drivers
Database
HTML DB, Raptor, PL/SQL
Target Audience
Developer Skills
Professional
.NET
MS Centric
JDeveloper
Java Centric
HTML DB
SQL Centric
Power
User Tactical
Departmental
Scope
Strategic
Enterprise
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, connection load
balancing, XA Connection Caching
• SQL Regular Expressions - support for key
Perl conventions
• Unicode 4.0 Support
• PL/SQL Compilation Versioning
SQL Developer / Project
Raptor
•
•
•
•
•
•
Database Development Productivity Tool
Targeted at the DBA - Developer
Rich Client SQL plus functionality
Optimizes out of box experience
Distributed initially via OTN
Requires no Oracle home; simple to install
Coming !
Application Express
(formally known as HTML DB)
• 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
QUESTIONS
ANSWERS
Descargar

Corporate PPT Template