Oracle Database 10g Release 2

1
Oracle Database 10g Release 2
New Features
2
Oracle Database 10g Release 2

• Infrastructure Grid
• High Availability
• Security
• Manageability
• Data/Content Management
• Application Development

3
Infrastructure Grid
4
Infrastructure Grid
Application Server Clusters
Real Application Clusters
Automatic Storage Management
5
Infrastructure Grid
Application Server Clusters
Real Application Clusters
Automatic Storage Management
6
ASM Disk Groups

• A pool of disks managed as a logical unit

Disk Group
7
ASM Disk Groups

• A pool of disks managed as a logical unit
• Divides total disk space into uniform sized
  megabyte units

Disk Group
8
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
9
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

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)
10
ASM Performance

• World record TPC-H 3TB result of 59,435.7
  QphH_at_3000GB
• Price performance ratio of 114.00/QphH_at_3000GB
• SunFire E25k with 72 1.2GHz UltraSparc IV on
  Solaris 10, Oracle Database 10g and Automatic
  Storage Management (ASM)
• Jan 31, 2005

11
Data Provisioning

• Online Transportable Tablespace
• Full Database Transport Within Same Endian
  Platforms
• Improved Oracle Streams Performance and
  Manageability
• Tablespace Repository

London
San Francisco
12
Infrastructure Grid
Application Server Clusters
Real Application Clusters
Automatic Storage Management
13
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
14
Oracle Clusterware

• Provides unified framework for managing
  applications and database using the same HA
  infrastructure

Apache
Non RAC database
Microsoft IIS
Non RAC database
listener
Custom Application
listener
listener
database
RAC db
RAC db
ORACLE_HOME
ORACLE_HOME
ORACLE_HOME
ORA_CRS_HOME
ORA_CRS_HOME
ORA_CRS_HOME
ORA_CRS_HOME
15
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 Eventstrue on connection string
• Service must have aq_ha_notificationsgttrue

16
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.

17
Runtime Connection Load Balancing with JDBC,
ODP.NET
connection cache
Instance 1
Instance 2
Instance 3
18
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

19
"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

20
High Availability
21
Oracle Secure Backup
File Systems

• 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
• 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
• Centralized management of network backups
• Scalability to low 100s of servers, 10s of
  millions of files
• Easy management through Enterprise Manager

Linux, Unix Windows, Filers
Databases
RMAN
Oracle Backup
Supports popular tape libraries drives
22
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/breakingn
ews.jhtml?articleId164900846
23
Fault Tolerant Standby
Automatic Failover
Physical or Logical Standby DB
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
• Comparable to cluster failover
• Original production site automatically rejoins
  the configuration after recovery

24
Fast Start Failover

• Test Scenario
• 2 Intel servers, RedHat Linux, running 10.2 beta
  2
• Simulated Workload 100 TPS, 100Kb/s redo

PRIMARY
STANDBY
The Observer
25
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

26
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

27
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)

28
Security
29
Transparent Data Encryption
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 Written To Disk Encrypted
Data Decrypted Through SQL Interface
Data Encrypted On Backup Files
30
Manageability
31
Management and Monitoring
32
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
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

34
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

35
Improved Job Scheduler
Bulk Load Job
Oracle Database 10g
YES
space?
New Data Event
Scheduler
NO

• Chaining
• Events
• Customized Calendars

36
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 AnandDirector of Database Systems
• Talk America

37
"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 DBAs job much easier, for
novices and experts alike."

• Arup Nanda,
• Lead DBA
• Starwood Hotels

38
Data / ContentManagement
39
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
• Industrys first XML Query Support

40
Native XML Query support in the Database
User

• XML Query is emerging as the consensus query
  language for XML
• Expected W3C Recommendation in 2006
• 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
41
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

42
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
43
Sort Performance Improvements
Test details in Sort Performance Improvements in
Oracle Database 10g Release 2 by Mark van de
Wiel, June 2005
44

• XML DB/XQuery Provides the Right Platform
• Unstructured and structured Data are combined in
  Contracts
• Extensibility to manage Dynamic Contract Formats
  and Content
• Contracts are stored in XML DB.
• Contract Metadata, Content, and Documents stored
  in XML DB
• XQuery and XPath queries are optimized for
  critical searching, querying, and reporting of
  contracts and ALL their associated attributes
• Meeting the Needs of Enterprise Deployments
• Number of Users 500 to 2500 active users are
  typical. Casual users can exceed 5000.
• Number of Contracts 100,000 to 500,000
  contracts are fairly typical for Fortune 1000
• Database size 60 to 250 GB

45
ApplicationDevelopment
46
HTML DB Release 1.6

• Improved User Interface

• Improved User Interface
• Improved Documentation and Online Help

47
Introducing Project Columbus
48
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

49
.Net Development

• Visual Studio Integration (delivery via OTN)
• Callout to Common Language Runtime
• ODP.Net Fast Connection Failover

50
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

51
A