11g general
TRANSCRIPT
-
7/31/2019 11g General
1/41
-
7/31/2019 11g General
2/41
Business and Technology Status 2007
Global economy is more dependent on ITthan ever before
Information management is THEmajor mission of the
enterprise
Organizations are being pushed toADAPTquickly to change
Economic, Technologic, Regulatory
At least two-thirds of all IT spending is just to sustain the business,
not to change or transform the business.
- Gartner Group
-
7/31/2019 11g General
3/41
Growing Data Volumes
Source: 2005 TopTen Program, November 2005 Winter Corporation, Waltham, MA, USA
0
20
40
60
80
100
1998 1999 2000 2001 2002 2003 2004 2005
Database
Size(TB)
Size of the largest
data warehouse in
Winter Corp Survey245% increase
from 2003
to 2005!
-
7/31/2019 11g General
4/41
Uptake (TAR Analysis)
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Mar.01
Haz.01
Eyl.01
Ara.01
Mar.02
Haz.02
Eyl.02
Ara.02
Mar.03
Haz.03
Eyl.03
Ara.03
Mar.04
Haz.04
Eyl.04
Ara.04
Mar.05
Haz.05
Eyl.05
Ara.05
Mar.06
Haz.06
Eyl.06
Ara.06
Mar.07
Oracle Database 10g Oracle9i Oracle8i Oracle8 and Earlier
Source: TAR Analysis (April 2007)
59%
36%
5%
-
7/31/2019 11g General
5/41
Infrastructure Complexity
Understanding the Costs
Number of things costs = N
Number of connected things = (2N)
Number of KINDS of things = N^N
Complexity Slows Change
More failure points
Uneven levels of process Maturity
Functionality+Virtualization=Agility
Functionality enables agility
Virtualization masks functional complexity
Oracle Grid is Enabling Enterprise Agility by AttackingOracle Grid is Enabling Enterprise Agility by AttackingComplexityComplexity
1 2 3 4 5 6 7 8
# of Things
# of Connections
# of Kinds
0
10
20
30
40
50
60
70
90
80
0
10
20
30
40
50
60
70
90
80
Complexity Cost CurveComplexity Cost Curve
-
7/31/2019 11g General
6/41
The 11g Big Message
11g Lowers overall costs while increasing business
and IT agility!
Simplifies your information infrastructure!
Enables change to happen while maintaining stability!
Takes management and diagnostic automation to the next
level! Freeing key personal for higher value tasks!
Provides the least expensive, most scalable, secure and
highly available rapid application development environment!
Traditional Performance Dimensions of Scalability andTraditional Performance Dimensions of Scalability andAvailability Are Now Table Stakes. Agility is the X-FactorAvailability Are Now Table Stakes. Agility is the X-Factor
-
7/31/2019 11g General
7/41
Defining Value Innovation Lowers the cost while increasing Agility
Simpler (automates/obfuscates complex tasks) Cheaper (lower TCO via improved sustainability)
More Convenient to Use
Most likely already own it
Solid skills base foundation
Single vendor to manage
Simplifies infrastructure landscape
Fundamentally changes how a task or process has been done in
the past
Value innovation fundamentally changes how oneValue innovation fundamentally changes how oneevaluates a product categoryevaluates a product category
-
7/31/2019 11g General
8/41
Oracle Database Innovation
Audit VaultDatabase Vault
Grid Computing
Self Managing Database
XML Database
Oracle Data Guard
Real Application Clusters
Flashback QueryVirtual Private Database
Built in Java VMPartitioning Support
Built in Messaging
Object Relational Support
Multimedia Support
Data Warehousing OptimizationsParallel Operations
Distributed SQL & Transaction Support
Cluster and MPP Support
Multi-version Read Consistency
Client/Server Support
Platform Portability
Commercial SQL Implementation
1977 2007
30 years ofsustainedinnovation
continuing withOracle Database 11g
-
7/31/2019 11g General
9/41
Bucking Conventional Wisdom
By The Book Oracle
Platform dependent Portable C code base
Read & write locks Multi-version concurrency
Combined undo/redo log Undo stored in the database
Static SQL compilation Just-in-time SQL compilation
Shared nothing clusters Shared disk/shared cacheclusters
Parallelism tied to partitions Parallelism orthogonal topartitions
Store some of your data Store all your data
-
7/31/2019 11g General
10/41
Database 1.0 Database 2.0
Users In-house Everyone
Applications Vertical Silos Horizontal Services
Data Chars, Numbers, Dates All Your Data
Hardware SMP/Mainframe Network/Virtualized
Storage Expensive, Siloed Inexpensive, Shared
Scalability High Cost Scale Up Low Cost Scale Out
WorkloadConsolidation
Specialized-SeparateDW-OLTP Slow TTV
Converging Workloads, FastTTV
HA Difficult, Expensive Easy, Low Cost
Management Monitor and Manage Alert and Automate
Pricing CPU or User Socket or Site
Where Weve Been, Where Were Going
-
7/31/2019 11g General
11/41
Top 11g new features
-
7/31/2019 11g General
12/41
Physical Standby with Real-Time Query
Physical Standby
Database
Primary
Database
Real-time
Queries
Continuous Redo
Shipment and Apply
Concurrent
Real-Time
Query
Read-only queries on physical standby concurrent with redo apply Supports RAC on primary / standby
Queries see transactionally consistent results
Immediate appeal to the many users of physical standby
DR with real time query is unique in the industry no idle resources
Handles all data types, but not as flexible as logical standby
-
7/31/2019 11g General
13/41
Set up Test Environments using
Snapshot Standbys
Convert Physical Standby to SnapshotStandby and open for writes by testingapplications
ALTER DATABASE CONVERT TOSNAPSHOT STANDBY;
Discard testing writes and catch-up toprimary by applying logs
ALTER DATABASE CONVERT TOPHYSICAL STANDBY;
Preserves zero data loss But no real time query or fast
failover
Similar to storage snapshots, but: Provides DR at the same time
Single copy of storage
Physical StandbyApply Logs
Snapshot StandbyPerform Testing
OpenDatabase
Back outChanges
Continuous Redo Shipping
-
7/31/2019 11g General
14/41
Database Replay
Capture Workload in Production
Capture production workload with actual load & concurrency
Move the captured workload to test system
Replay Workload in Test
Make the desired changes in test system Replay workload with production load & concurrency
Analyze & Report
Errors
Data divergence
Performance divergence
Use ADDM, AWR for further performance analysis
-
7/31/2019 11g General
15/41
Pre-Change Production System
ClientClient
App ServerApp ServerApp Server
Client
Backup
CapturedWorkloadProcess Process Process
Capture Workload
ChangesUnsupporte
d
ChangesSupported
Database Upgrades, Patches
Schema, Parameters
RAC nodes, Interconnect
OS Platforms, OS Upgrades
CPU, Memory
Storage
Etc.
-
7/31/2019 11g General
16/41
Post-Change Test System
ReplayDriver
App ServerApp ServerApp Server
Process Process Process Process Process Process
Can use Snapshot Standby astest system
ReplayDriver
ClientClient
Client
Pre-Change Production System
ProcessedCapturedWorkload
Backup
Capture Workload
-
7/31/2019 11g General
17/41
SQL Performance Analyzer
Focus on impact of change on SQL query workload
Capture SQL in Production Automatically capture SQL workload over a specified period
Capture SQL text, plans, bind variables, execution statistics
Can capture 10.2 SQL workload
Move captured SQL workload to test system
Replay SQL in Test Replay SQL in pre and post-change configurations
Compare and analyze performance
For regressed SQL, use SQL Tuning Advisor (10g) to improveperformance with SQL Profiles
Changes supported Major & minor database releases, patches, parameters, schema,
optimizer statistics, tuning recommendations
-
7/31/2019 11g General
18/41
SQL Performance Analyzer
-
7/31/2019 11g General
19/41
SQL Plan Managementcontrolled plan evolution
Business Requirement Data is changing over time
Statistics and execution plans become suboptimal
Statistics have to be updated
Possibly unpredictable changes of execution plans
Today you have freeze critical plans or statistics
Solution
Optimizer automatically manages SQL Plan Baselines
Only known and verified plans are used
Plan changes are automatically verified in maintenance window Only comparable or better plans are used going forward
Can pre-seed critical SQL with baselines from SQL Replay
-
7/31/2019 11g General
20/41
Flashback Data Archive
Automatically stores all
changes to selected tables
Archive cannot be modified
View table as of any time
Uses:
Change Tracking
ILM
Long term history - years
Auditing Compliance
ORDERS
User
Tablespaces
Flashback
Data Archive
Archive
Tables
Oracle Database
Changes
Select * from ordersAS OF
Midnight 31-Dec-2004
-
7/31/2019 11g General
21/41
EM Support Workbench Overview
Wizard that guides you through the process of handling problems
You can perform the following tasks with the Support
Workbench:
View details on problems and incidents
Run health checks Generate additional diagnostic data
Run advisors to help resolve problems
Create and track service requests through MetaLink
Generate incident packages Close problems once resolved
-
7/31/2019 11g General
22/41
Support Workbench
-
7/31/2019 11g General
23/41
Incident Packaging Service
-
7/31/2019 11g General
24/41
Manageability Evolution
Storage
Backup
Memory
Apps/SQL
Schema
RAC
Recovery
Replication
Auto-TuningTuning
Advisory
InstrumentationLowImpact
Integrated
Adaptive
-
7/31/2019 11g General
25/41
Manageability in 11g?
More database administration automation
More intelligent advisors to simplify administration
Fault diagnostic automation
Enhancements to existing features
-
7/31/2019 11g General
26/41
0%
25%
50%
75%
100%
T ime Steps
9i
10 g
11 g
Manageability Comparison ofOracle Database 9i, 10g, and11g
SummarySummary Oracle 9i vs. 10g 44% less time
47% fewer steps
Oracle 9i vs. 10g 44% less time
47% fewer steps
Oracle 10g vs. 11g 26% less time
31% fewer steps
Oracle 10g vs. 11g 26% less time
31% fewer steps
-
7/31/2019 11g General
27/41
DB Management Pack Enhancements
Diagnostic Pack
ADDM for RAC
AWR Baselines
Transportable AWR
Tuning Pack
Automatic SQL Tuning Advisor
Partition Advisor SQL Monitoring
SPM Automatic Plan Evolution
-
7/31/2019 11g General
28/41
-
7/31/2019 11g General
29/41
Table Compression
Introduced in Oracle9i Release 2
Supports compression during bulk load operations (Direct Load, CTAS)
Data modified using conventional DML not compressed
Optimized compression algorithm for relational data
Improved performance for queries accessing large amounts of data
Fewer IOs Buffer Cache efficiency
Data is compressed at the database block level
Each block contains own compression metadata improves IO efficiency
Local symbol table dynamically adapts to data changes
Compression can be specified at either the table or partition levels Completely transparent to applications
Noticeable impact on write performance
-
7/31/2019 11g General
30/41
OLTP Table Compression
Oracle Database 11g extends compression for OLTPdata
Support for conventional DML Operations
(INSERT, UPDATE, DELETE)
New algorithm significantly reduces write overhead Batched compression ensures no impact for most OLTPtransactions
No impact on reads
Reads may actually see improved performance due to fewer
IOs and enhanced memory efficiency
-
7/31/2019 11g General
31/41
-
7/31/2019 11g General
32/41
-
7/31/2019 11g General
33/41
-
7/31/2019 11g General
34/41
SecureFiles - Compression
Huge storage savings
Industry standard compression algorithms 2-3x compression for typical files (doc, pdf, xml)
Minimal CPU overhead during compression
Automatically detects if SecureFile data is compressible Skips compression for already compressed data
Auto-turn off compression when space savings are minimal or zero
Two levels of compression provide different compression ratios Compression Levels:MEDIUM (default), HIGH
Higher the degree of compression, higher the latency and CPU overheadincurred
SecureFiles Compression is independent of table or index
compression Server-side compression Allows for random reads and writes to SecureFile data
Can be specified at a partition level
-
7/31/2019 11g General
35/41
Data Pump Compression
Metadata compression available since Oracle Database 10g
Oracle Database 11g extends compression to table data during
exports
no need to decompress before import
Single step compression of both data and metadata
compressed data directly hits disk resulting in reduced disk spacerequirements
75% reduction in dump file size on export of sample OE and SH
schemas
Compression factor comparable to GNU gzip utility
Application transparent complete Data Pump functionality available on compressed files
-
7/31/2019 11g General
36/41
Backup data and Network transport
Compression
Fast RMAN Compression
compresses the backup set contents before writing them to disk or
tape
no extra decompression steps are required during recovery when
you use RMAN compression.
high performance, industry standard compression algorithm
40% faster backup compression versus Oracle Database 10g
suitable for fast, incremental daily backups
reduces network usage
Data Guard Network Compression compression of redo traffic over the network
improves redo transport performance
gap resolution is up to 2x faster
-
7/31/2019 11g General
37/41
Oracle SecureFilesHigh-Performance Large Objects
High-performance transactional
access to large object data
documents, medical, CAD, imaging
low-latency, high throughput, concurrent access
space-optimized storage
Protect your valuable data .. in the db!
transactions
transparent encryption
compression and de-duplication
database-quality security, reliability, and scalability
Better security, single view and management of data
Superset of LOB interfaces easy migration
-
7/31/2019 11g General
38/41
0
2 0
4 0
6 0
8 0
1 0 0
1 2 0
0 ,1 1 1 0 1 0 0
LOBs
Linux Files
SecureFiles
Innovative technology for high
performance large object data
Smart buffering, write gathering,
intelligent lockingFast bulk data transfers, LOB
prefetch
Much faster than LOBs with
more capabilities
File system-like performance
with database functionality!File Size (MB)
SecureFiles Breaks the
Performance Barrier!
File Read Performance(MB/second)
O l P titi i
-
7/31/2019 11g General
39/41
Oracle Partitioning10 years of innovation
Core functionality
Oracle8 Range partitions, global range index
Oracle8i Hash and composite range-hash partitioning
Oracle9i List partitioning
Oracle9i
R2 Composite range-list partitioningOracle 10g Global hash indexes
Oracle 10gR2 1M partitions per table
O l P titi i
-
7/31/2019 11g General
40/41
Oracle Partitioning10 years of innovation
Core functionality
Oracle8 Range partitions, global range index
Oracle8i Hash and composite range-hash partitioning
Oracle9i List partitioning
Oracle9i
R2 Composite range-list partitioningOracle 10g Global hash indexes
Oracle 10gR2 1M partitions per table
Partitioning by referenceVirtual column partitioningNew composite partitioning:
range-range, list-range,list-list, list-hash
-
7/31/2019 11g General
41/41
New Partitioning
Features New composite partitioning schemes
Partition (or index) on virtual (computed) columns
Partition advisor Automatic range partition creation
Partition by REFERENCE (primary key of parent)
Range List Hash
Range 11g 9i 8i
List 11g 11g 11g