Transcript Corporate PPT Template

Oracle Database 10g
Release 2
New Features
Oracle Database 10g Release 2






Infrastructure Grid
High Availability
Security
Manageability
Data/Content Management
Application Development
Infrastructure Grid
Infrastructure Grid
Application
Server
Clusters
Real
Application
Clusters
Automatic
Storage
Management
Infrastructure Grid
Application
Server
Clusters
Real
Application
Clusters
Automatic
Storage
Management
ASM Disk Groups
 A pool of disks managed as a
logical unit
Disk Group
ASM Disk Groups
 A pool of disks managed as a
logical unit
 Divides total disk space into
uniform sized megabyte units
Disk Group
ASM Disk Groups
 A pool of disks managed as a
logical unit
 Divides total disk space into
uniform sized megabyte units
 ASM spreads each Oracle file
evenly across all disks in a
disk group
Disk Group
Automatic Storage Management
 Improved ease-of-use
and configuration
 Enhanced data
provisioning
Non-RAC database (10.1)
RAC database (10.2)
RAC database (10.2)
RAC database (10.2)
ASM (10.1)
ASM (10.1)
ASM (10.1)
CSS (10.2)
CSS (10.2)
CSS (10.2)
–
Support transportable
tablespaces
 Enhanced storage
virtualization
–
–
Support multiple
databases in a cluster
Support databases at
multiple release levels
ASM Performance
 World record TPC-H 3TB result of 59,435.7
QphH@3000GB
 Price performance ratio of
$114.00/QphH@3000GB
 SunFire E25k with 72 1.2GHz UltraSparc IV
on Solaris 10, Oracle Database 10g and
Automatic Storage Management (ASM)
 Jan 31, 2005
Data Provisioning
London
 Online Transportable
Tablespace
San Francisco  Full Database
Transport Within Same
Endian Platforms
 Improved Oracle
Streams Performance
and Manageability
 Tablespace Repository
Infrastructure Grid
Application
Server
Clusters
Real
Application
Clusters
Automatic
Storage
Management
Real Application Clusters
 Improved Robustness
–
–
Cluster Verification
Utility
Improved OCR, Voting
Disk resilience
 Oracle Clusterware for
integrated application
availability
 Load Balancing Advisory
 Certified to 100 nodes
 Improved performance
ERP
CRM
DW
Oracle Clusterware
 Provides unified framework for managing applications
and database using the same HA infrastructure
Apache
Non RAC database
Non RAC database
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
Extended FAN/FCF Client Integration
 Oracle Call Interface
–
standalone,TAF, connection pool, and session pool
connections are automatically broken and cleaned up by
OCI and the application callback is invoked within seconds
of the failure event.
 ODP.NET
–
–
FAN notifies ODP.NET which allows it to clean up
resources from severed connections or establish new
connections
HA Events=true; on connection string
 Service must have aq_ha_notifications=>true
RAC Load Balancing Advisory
 Monitors workload activity for a service across all
instances in the cluster
 Analyzes the service level for each instance based on
defined goal (service time or throughput)
 Publishes FAN events describing the current service
level, amount of work to be sent to each instance and
data quality flag
 If no goal defined, no load balancing events sent.
Runtime Connection Load
Balancing with JDBC, ODP.NET
CRM Client connection requests
connection
cache
?
60%
“CRM is
bored”
30%
10%
“CRM is
very
busy”
Instance 1
Instance 2
Instance 3
“CRM is
busy”
Oracle Enterprise Manager Grid
Control - RAC Enhancements
 Interconnect Monitoring
 Topology View
 Automated Conversion of Single Instance to
RAC
 Automated Add/Delete Instance
 Cloning of Oracle Home for Oracle
Clusterware and RAC
"The clustered pool of storage managed by
the ASM feature in Oracle Database 10g
Release 2 presents new key opportunities for
Vanderbilt to improve storage utilization and
save money through database storage
consolidation in a single instance Oracle
Database 10g as well as Real Application
Clusters (RAC) environments"
- Darryl Boone
MIS Director
Vanderbilt University
High Availability
Oracle Secure Backup
File Systems
Linux, Unix
Windows,
Filers
 Oracle Secure Backup is ideal for customers seeking a
low cost alternative to complex backup products
 Best integrated end-to-end backup of Oracle Databases
–
Databases
–
Media manger for RMAN backup and recovery of
Oracle9i and 10g databases to tape
Fastest Database Backup on the market
 Backup Oracle Home, App Server and other file systems
 Oracle Secure Backup includes:
–
–
–
Supports popular tape
libraries & drives
Centralized management of network backups
Scalability to low 100’s of servers, 10’s of millions of files
Easy management through Enterprise Manager
“We're definitely looking at the new
backup for cost savings. We pay a lot of
money for Legato licenses, and this
seems comparable”
- Aris Prassinos
Distinguished Member of Technical Staff
Motorola's Biometrics Business Unit
http://www.crn.com/sections/breakingnews/breakingnews.jhtml?articleId=164900846
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
Fast Start Failover
 Test Scenario
–
–
2 Intel servers, RedHat Linux, running 10.2 beta 2
Simulated Workload 100 TPS, 100Kb/s redo
Scheduled Outage
for switchover
Unscheduled Outage
less than 1 minute
PRIMARY
ACTIVE
PRIMARY
30 secs
<30 secs
STANDBY
ACTIVE
STANDBY
The
Observer
<2 mins
Wait for
Failure
Detection
Automatic
Failover
Restart
Production
Graceful
Switchover
Reinstates
Production
“Airbus testing of Oracle Database 10g
Release 2 Data Guard Fast-start Failover
produced impressive results. Failover
executed automatically without manual
intervention in less than a minute. This
was much faster than a cold failover using
third party cluster technology.”
- Werner Kawollek
Application Management Operations
Airbus Deutschland GmbH
“Data Guard's rolling upgrade capability is
amazing. Airbus tested upgrading from Oracle
Database 10g Release 1 to release 2 using this
feature. The elapsed time for the database upgrade
was about 3 hours. But applications were available
for all but less than 2 minutes while a Data Guard
switchover was executed, quickly transitioning
production from the previous database release to
Oracle Database 10g Release 2.”
- Werner Kawollek
Application Management Operations
Airbus Deutschland GmbH
Oracle Database 10g Release 2 –
Online Redefinition Enhancements
 Online Redefinition supports
–
–
–
–
–
Online Move of a partition of a partitioned table
AQ tables
Clustered Tables
Materialized View Logs
Abstract Data Types (Objects)
Security
Transparent Data Encryption
 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
Manageability
Management and Monitoring
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
Improved Database 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
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
Improved Job Scheduler
“Bulk Load” Job
Oracle Database 10g
YES
Do_bulk_load
space?
“New Data” Event
Rebuild_indx
Scheduler
NO
Recalc_stats
 Chaining
 Events
 Customized Calendars
Run Reports
“Oracle Database 10g Release 2 offers significant
new automations that make database
management even easier. New features such as
Automatic Segment Advisor and Dynamic Metric
Baselines, to name a few, make my job
considerably easier and allow me to focus more
on strategic business IT issues and less on
mundane day-to-day database management
activities”
- Vishal Anand
Director of Database Systems
Talk America
"Oracle Database 10g Release 2 builds upon the
manageability enhancements of its first release
and now its administration is even simpler than
before. It has introduced many new great
features that will make the DBA’s job much
easier, for novices and experts alike."
- Arup Nanda,
Lead DBA
Starwood Hotels
Data / Content
Management
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 2006
XML
Query
–
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
New in-Memory Sort Algorithm
 New improved sort implementation
–
Hash-based implementation
 Dramatic transparent performance improvements
–
–
Fully leverages large amounts of memory
Sort operation can be up to 5 times faster (*)
 Improvements depending on sort characteristics
–
–
–
(*)
Higher cardinality, more improvements
Faster CPU, more improvements
Select fewer columns, more improvements
Total improvement depends on the weight of the sort in the overall operation
Application
Development
HTML DB Release 1.6
 Improved User
Interface
 Improved
Documentation and
Online Help
 Master Detail Wizard
 Charting
Enhancements
Introducing: Project Columbus
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
.Net Development
 Visual Studio
Integration (delivery
via OTN)
 Callout to Common
Language Runtime
 ODP.Net Fast
Connection Failover
Oracle Database 10g Release 2 Summary
 Lowest Cost
–
–
–
–
Oracle Backup
Improved Sort
Streams Performance
Oracle Clusterware
 Highest Quality of Service
–
–
–
Rolling Upgrades
Fast-Start Failover
Transparent Data
Encryption
 Easier to Manage
ERP
CRM
DW
Q U E S T I O N S
A N S W E R S