Docstoc

Grid

Document Sample
Grid Powered By Docstoc
					Enterprise Applications
 Product Family
   –   Contracts, Corporate Performance Management, Customer
       Relationship Management, Financials, Human Resources, Interaction
       Center, Intelligence, Maintenance Management, manufacturing,
       Marketing, Order Management, Procurement, Product Lifecycle
       Management, projects, Sales, Service, Supply Chain Planning, Supply
       Chain Management




                                                         Oracle Ebusiness Suite
                                                         online document available
Infrastructure Software
A Brief look at Oracle‟s Database
History
 Oracle 7
   –   Oracle Parallel Server
 Oracle 8i
   –   Transition to Real Application Clusters begins
 Oracle 9i
   –   Integrated Data Warehousing
   –   Real Application Clusters
 Oracle 10g
   –   New grid capable features
Federated Database
                      A logical unification of
                       distinct databases
                      Independent servers
                      No shared resources
                       (including disk)
                      Connected by LAN
Shared Disk Architecture
                    Equal access to all
                     disks
                    No notion of data
                     ownership on any node
                    Managed by Oracle‟s
                     Real Application
                     Clusters (RAC)
Shared Disk Architecture: Scalable
 Nodes can be dynamically added and
  removed from the grid
 Adding and removing nodes does not
  require data to be redistributed
 Multi-version read consistency model
 Based upon Real Application Clusters
Multi-Version Read Consistency

 Writers never block readers and readers never block
  writers
 Data is tracked by a System Change Number (SCN)
 Always provides consistent and accurate results
 Non-escalating row-level locking
    –   Locks are contained at the row level
Example: System Change Number
Shared Disk Architecture: Availability
 The loss of a cluster node does not cause a
  loss of data
 The loss of a cluster node does not cause
  another node to “take over” data
 Processes can be redistributed to other
  nodes
    Traditional Shared-Disk Clustered
                Databases


 Maintaining data coherency is a hard
  problem
    –   Need to synchronize updates to shared data
    –   The disk is the only medium for data sharing
 Disk I/O latencies appear in the critical path
  when multiple nodes access shared data
 Disk-based coherency is the main bottleneck
  to achieving a scalable shared disk cluster
    –   Only synthetic fully partitioned workloads scale!
  Oracle Real Application Clusters
               (RAC)
 An application transparent clustered database
   –   single node applications run and scale with no
       changes
 Cluster interconnect fabric replaces the disk
  as the medium for inter-node data sharing
 Cache Fusion protocol for data sharing results
  in a scalable cluster for OLTP and DSS
  workloads
Oracle RAC
Architecture



Centralized                             Application Servers/              Users
Management                                    Network
Console
                     Low Latency Interconnect
                                                               No Single
High Speed
Switch or
                                                               Point Of Failure
Interconnect


Clustered
Database Instances



Hub or
Switch                                                         Storage Area Network
Fabric
                                                               Drive and Exploit
Mirrored Disk                                                  Industry Advances in
Subsystem                                                      Clustering
        What is Cache Fusion?

 The underlying technology that enables RAC
 Protocol that allows instances to combine
  their data caches into a shared global cache
   –   Global Cache Service (GCS) coordinates sharing
 Key features are
   –   Direct sharing of volatile buffer caches
   –   Efficient inter-node messaging framework
   –   Fast recovery from node failures using cache and
       CPU resources from all surviving nodes
          Data Sharing Problem

 Read Sharing for Queries
    –   query needs to read a data block that is currently
        in another instance‟s buffer cache.
 Write Sharing for Updates
    –   update needs to modify a data block that is
        currently in another instance‟s buffer cache.
 With Cache Fusion, a disk read is performed
  only if the block is not already in the global
  shared cache
   Cache Fusion Read Sharing

 Uses Oracle‟s Consistent Read (CR) scheme
   –   undo is applied to make a block transactionally
       consistent to a System Change Number (SCN).
   –   a CR copy is shipped to the requesting instance

                            1
        Query                               225   Data Block
       SCN 200                          2
                            3
                                            200   CR Copy

  Instance A                                 Instance B
    Cache Fusion Write Sharing

 Multiple dirty copies of a data block can exist
  in the global cache, but only one is current
 The current copy can move between
  instances without first being written to disk
    –   Changes are logged if not already on disk
 Non-current dirty copies can directly service
  queries from any node and instance recovery
     Cache Fusion Write Sharing

Instance A                        Instance B
                     4

Update                               Current
Block 10                              225
                                     3
             1   Master       2
                                         Copy
                                          225

Requester          GCS              Holder


    200
                 Instance C
  Efficient Inter-Node Messaging

 Messaging cost independent of cluster size
    –   At most 3 nodes involved in a request
          requester, holder and master (directory)
          number of messages to service a request is bounded
 Inter-Node Message Latency
    –   exploits high performance interconnect substrates so that
        on-the-wire message transmission times are minimal
 Frequency of Inter-Node Synchronization
    –   adaptive directory migration based on access patterns
    –   fast reconfiguration of resources when a node joins/leaves
   Oracle Grid Computing Goals
     Storage     Database      Application    Grid
       Grid        Grid           Grid       Control




 Half the Cost
 Highest Quality of Service
 Easiest to Manage
Problem with Today‟s IT
Infrastructure
 Islands of Computing
  Resource
    –   Some are melting
        down
    –   Some are almost idle
 High Costs                              CRM
    –   Hardware               ERP
    –   Labor
    –   Software
 Hard to Align
  with Business
  Priorities
                                     DW
    Solution: Computing On Demand
   Mainframe Model             Grid Computing Model




 Partitioning of one large     Coordinated use of many
  server                         small servers
 Built with high quality,      Built with low cost, standard,
  high cost parts                modular parts
 Complete, integrated          Open, Complete, integrated
  software                       software
 High quality of service at    High quality of service at
  high cost                      low cost
Early Grid Computing

 Desktop Grids
   –   SETI@home
 Scientific Research Grids
   –   Globus Toolkit, CERN




  What about Grids for the Enterprise?

                                 11
Requirements for Enterprise Grids
   Run all your applications
   Stores all your information
   Highly scalable, available, reliable
   Secure
   Easy to manage
      –   Make individual systems self-managing
      –   Manage thousands of servers at once
    Introducing Oracle 10G
 Runs all your applications
 Stores all your information
 Highly scalable, available,
  reliable
 Secure
 Easy to manage
     –   Make individual systems
         self-managing
                                   10G 10G
     –   Manage thousands of
         servers at once
Oracle Database 10G –
 The First Database
Designed for the Grid
Orders of MAGNITUDE…

   ~354 NEW 10g features *
   @5 slides / feature *
   @2 minutes /slide
   = 4.5 DAYs [ 9 hour/day ]
Oracle Database 10G –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
Oracle Database 10G –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
Oracle Database 10G –
Align Storage with the Business
 Problem: Islands of
  storage
    –   “My storage is 50%
        utilized
        and growing 30% a
                                        CRM
        year”
                             ERP




                                   DW
        Oracle Database 10G –
        Align Storage with the Business


 Problem: Islands of storage
    –   “My storage is 50% utilized
        and growing 30% a year”
 Solution: Groups of
  standard, modular disks
    –   Consolidated,
        Networked Storage
    –   Dynamically Provision
     Oracle Grid Storage Management
     Highly Available and Low Cost
 Oracle Automatic Storage
  Management
    –   Manages disk storage groups
    –   Mirrors, Stripes, Re-balances
    –   Huge reduction in labor cost
 Built-In Data Protection at
  Lowest Cost
    –   Disk Based Backup and
        Recovery
                                        Automatic Storage   Disk Based
    –   Flashback in Time                 Management         Backup &
    –   Site Recovery                                        Recovery
Automatic Storage Management –
Dynamically Provision and Tune
Storage
               Portable, high performance
                file system
               Eliminates need for
                conventional file system and
                volume manager
               Automatic mirroring
               Automatic I/O tuning
                  –   Stripes data across disks to
                      balance load
   The Operational Stack
   TODAY                                      ASM


  Tables                                    Tables
  Tablespace                                Tablespace
                 0010 0010 0010 0010 0010
   Files         0010 0010 0010 0010 0010
                                            Files
  File System                               File System    ASM
  Logical Vols                              Logical Vols
     Disks                                  Disk Group


“The best way to lower mgmt costs is to remove complexity”
   ASM Disk Groups
                      A pool of disks managed as a
                       logical unit
                      Partitions total disk space into
                       uniform sized megabyte units
                      ASM spreads each file evenly
                       across all disks in a disk
                       group
                      Coarse or fine grain striping
                       based on file type
                      Disk groups integrated with
                       Oracle Managed Files
Disk Group
      ASM Disk Groups
                        • Administer disk groups not files
                        • Number of disk groups remains
                          constant while number of files
                          and disks continually increases




Fast Disk Group   Slow Disk Group
  Mirroring with ASM
  Failure Groups

                                   Storage resources organized into
                                     Disk Groups and Failure Groups
                                   A Disk Group is a collection of disks
                                    managed as a logical unit in which ASM
                                    files are stored
 Controller 1     Controller 2
                                   Disk Groups assigned by DBAs
                                   A Failure Group is a set of disks sharing
                                    a common resource whose failure
                                    needs to be tolerated
                                       –   Redundant copies of an extent are
                                           stored in separate Failure Groups
                                   Failure Groups assigned by DBAs or
Failure Group 1 Failure Group 2
                                    automatically by ASM
Disk Group 1
                 Automatic Storage Management –
                 Lowest Labor Cost
                                                                    8
                          7             7
            8
                                                      6                            6            6
            7
            6
                     5
            5
Nbr Steps




                                                              4
            4
            3
                                2               2
            2
                                                                                                          Traditional
            1                                                                0             0        ASM
            0
                Install   Add Storage       Remove        Migrate       Tune I/O       Manage
                                            Storage       Storage                      Space
               ASM Delivers Great Performance
               with no Manual Tuning

                              22,648
       24000


       20000
                                                    20,590
       16000
TpmC




       12000


        8000


        4000


           0
                   ASM (24 Disks)      VxVM (24 Disks, 12 s)
Automatic Storage Management -
Mission Critical, Low Cost Storage
for Enterprise Grids
 Mission-critical
    –   Integrated mirroring
    –   Add/drop disk online
    –   Best I/O performance
 Easy
    –   Automatic I/O Tuning
    –   Up to 50% less DBA/Sys Admin work
 Low Cost
    –   Works well with inexpensive disks
    –   Better storage utilization
  Oracle DB 10G Stores All Your Data

 Complete                   Relational
                    Characters, Numbers and Dates
 Integrated
                            Oracle Text
                      Text management and search

                         Oracle interMedia
                        Multimedia management

                          Oracle Locator
                    Location and Proximity Searching

                              XML DB
                    Integrated Native XML Database

                             OCS Files
                           Low-cost and Easy


                                                       41
  Oracle DB 10G ULDB - Stores
         ALL Your Data
 Database size limit raised to millions of
  Terabytes (8 Exabytes)
 Ultra Large Data Files – Terabytes in
  single file
 Unlimited size LOB columns – Terabytes
 Automatic Storage Management removes
  file system limits
Oracle Database 10G –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
Align Processing with the Business

 Problem: Islands of
  computation
    –   “My servers are 15%
        utilized“
                                         CRM

                              ERP




                                    DW
Align Processing with the Business

 Problem: Islands of
  computation
    –   “My servers are 15%
        utilized“
 Solution: Groups of
  industry standard
  servers
    –   Lowest cost, highest
        performance
    –   Capacity on demand
    –   Not Self-healing,
        Disposable
Oracle Database 10G RAC
Capacity on Demand for the Grid
 Only Cluster
  Database that runs
  Real Applications and
  Scales                  ERP   CRM   DW
 Highly Available
 Runs on standard,
  low cost servers
 Proven
    –   Hundreds of
        customers
    –   Certified with
        leading apps
Automatic Workload Management


          Order Entry   Spare   Supply Chain




               Normal Server Allocation
Automatic Workload Management


              Order Entry       Supply Chain




                    End of Quarter
  Oracle Database 10G RAC -
  Complete, Integrated Clusterware
 Complete Oracle cluster
  software solution
 Single-vendor support
 Low Cost
     –   No need to purchase
                                     Services Framework
         additional software       Cluster Control/Recovery
     –   Easy to install, manage   Messaging and Locking
                                         Connectivity
 High quality and functionality
  across all platforms
 Common event and
  management API‟s
 Support for third-party
  clusterware
Benefits of Integrated Clusterware

 Lower software cost
 Easy
   –   Deploys in hours not days
   –   Single integrated target for cluster
       management provides improved single
       system image
 Less Risk
   –   Same high functionality and quality across
       platforms
   –   Single vendor support
Automatic Server Provisioning
 Push-button add/drop server to cluster
 Hands-free allocation and re-allocation of
  servers to services
   –   Automatic routing of service requests to
       appropriate server with lowest load
   –   On server failure, automatic re-allocation of
       surviving servers to services
 Works across all platforms
Oracle RAC 10G - Only Solution for
Enterprise Grids
    Mission Critical Quality of Service on
     Industry Standard, Low Cost Servers
    Complete, Integrated Oracle Clusterware
    Runs all Applications
    Provides Capacity on Demand
    RAC Made Easy for Everyone
    Automatic Server Provisioning
Oracle Database 10G –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
   Low Cost Fault Tolerance
            Computer
             Failures
Unplanned
Downtime      Data
            Failures


            System
 Planned    Changes
Downtime
              Data
            Changes
   Low Cost Fault Tolerance
            Computer    Oracle10G RAC
             Failures    Integrated
Unplanned                 clusterware
Downtime      Data         –   Integrated, less
            Failures           moving parts, better
                               tested
                         Faster failover
            System        between servers
 Planned    Changes        –   Single digit seconds
Downtime
              Data
            Changes
   New Economics for
   Data Protection & Recovery
            Computer
             Failures
Unplanned               Disk-Based Recovery
Downtime      Data
            Failures
                        Trade cheap disk space
                        for expensive downtime
            System
 Planned    Changes
Downtime
              Data
            Changes

                                           56
         Flashback Database

                                   New strategy for point-in-time
                       Old          recovery
     Disk Write       Block        Flashback Log captures old
 New                 Version        versions of changed blocks
 Block                                 –   Think of it as a continuous
Version                                    backup
                  Flashback Log        –   Replay log to restore DB to time
                                       –   Restores just changed blocks
                                   It‟s fast - recovers in minutes, not
                                    hours
    Like a “Rewind” button         It‟s easy - single command
        for the Database            restore
                                       –   SQL> Flashback Database to
                                           „2:05 PM‟
       Flash Backup
                                      Fully automatic disk-
                                       based backup and
                                       recovery
                                          –   Set and Forget
                                      Nightly incremental
                                       backup rolls forward
                                       recovery area backup
                                          –   Changed blocks are
Database Area   Recovery Area Tape            tracked in production
                                              DB
                                          –   Dramatically faster
       Nightly Apply    Weekly                (20x)
             of        Archive to     Use low cost ATA disk
        Incremental      Tape          array for recovery area
          Backup
         Oracle Database 10G Highest Data
         Protection for Lowest CostData Guard
                                                    Redo
                                                   Shipping

                                    Flash Backup   Site Failure
                                                   Protection


                                      On Disk
                    Flashback         Backups

                                     Corruption
                   Flashback Logs
                                     Protection
ASM Mirroring       Human Error
                      Protection




 Storage Failure
   Protection
   No Cost System Changes
            Computer            Goal
             Failures
                         Allow any change to
Unplanned
Downtime                  the system with no
              Data
            Failures      downtime


            System       Online Reconfiguration
 Planned    Changes
                            Rolling Upgrades
Downtime
              Data
            Changes

                                               60
             Oracle10G High Availability Features

 Backup and Recovery          Backup and Recovery           Data Guard (Cont)         Flashback
  –   Automated Disk-           (Cont)                          –   Fine-Grained             – Flashback Database
      Based Backup and           –   Incrementally                  Supplemental             – Flashback
      Recovery                       Updated Backups                Logging                    Reinstantiation
  –   Drop Database              –   Simplified Recovery        –   Named Data Guard         – Flashback Standby
  –   RMAN Database                  Through Resetlogs              Configurations             Database
      Deregistration             –   Restore Tolerates          –   Simplified Zero Data     – Flashback Table
  –   Backup of Standby              Corrupt or Missing             Loss for Data Guard      – Flashback Row
      Control File                   Backups                        SQL Apply                  History
  –   Automated TSPITR           –   Full Database Begin        –   Zero Downtime            – Flashback Drop
      Instantiation                  Backup Command                 Instantiation for SQL    – Flashback
  –   Simplified Recovery        –   Change-Aware                   Apply
                                                                                               Transaction History
      Manager Cataloging             Incremental Backups        –   Real Time Apply
      of Backup Files                                               Redo Data and          Online Operations
                               Data Guard                      –
                                                                                             – Enhanced Online
  –   Automated Channel                                             Archivelog
                                 –   Data Guard Broker              Compression                Redefinition
      Failover for Backup            Support for RAC                                         – Improved Handling of
      and Restore
                                 –   Automated LogMiner                                        DDL Locks on Busy
  –   Automated File                 Configuration
      Creation During                                                                          Tables
      Recovery                   –   Log Miner Support for                                   – Signature-Based
                                     Index-Organized                                           Dependency Tracking
  –   Simplified Backups to          Tables
      Disk                                                                                     Using Synonyms
                                 –   Secured Redo                                            – Rolling Upgrades
  –   Proxy Copy Backup              Transmission
      of Archivelogs                                                                           with Data Guard SQL
                                                                                               Apply
Oracle Database 10G –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
  Oracle Database 10G Ease of
  Management

 Self-Managing
  Database
 OEM Grid Control
   –   Grid-wide
       operations
   –   Scale from one to
       hundreds of
       systems with little
       incremental cost
           Business Challenge –
           How to Scale DBA‟s to the Grid ?

                                 Installation
                                     6%
                                                Creation &
        Others
                                                Configuration 12 %
         15%




       Software                                 Data
Maintenance 6%                                  Loading 6%
                               Ongoing System
                               Management 55%




Source: IOUG 2001 DBA Survey
   Oracle10G System Management –
   Built-In Intelligent Infrastructure
 Automatic Workload
  Repository
    –   Automatically collects
        statistics, SQL workload,
        Feature usage
 Automatic Maintenance
  Tasks
    –   Pre-packaged, resource
        controlled
 Server-Generated Alerts
    –   Out-of-the-box, Push vs.
        Pull, Just-in-time
         Oracle10G System Management –
         Automatic SGA Management
                                                            Only 2 memory
Online                  Large Batch   Buffer Cache            parameters
Users    Buffer Cache      Jobs                             Advisor helps
                                                              set parameters
                                      Large Pool
         Large Pool                                         Automatically
                                                              resizes with
         SQL Cache                    SQL Cache
                                                              changes in
                                                     SGA Pool workload
         Java Pool                     Java Pool
                                                            Maximize usage
                                                     PGA Pool

            sort                         sort
                                                              of available
                                                              memory
   Oracle10G System Management –
   Self Optimizing SQL Management
 Oracle Query Optimizer – Proven Technology
    –   Comprehensive set of access paths, adaptive search
        strategy
    –   All cost-based transformations
    –   Preconfigured task to collect object and system statistics
    –   If no statistics available, are collected at parse-time
 Automatic memory allocations, automatic degree of
  parallelism
 Automatic identification and capture of high-load
  SQL
    –   Automatic SQL Tuning
    –   Automatic SQL Analysis
    –   SQL Access Advisor
     Oracle10G System Management –
     Self Optimizing SQL Management
                 High-load                    Automated capture
                   SQL
 Packaged
Applications
                                Custom
                              Applications
                                               and identification of
                                               high-load SQL
                Optimizer                     Automatic SQL
                                               Tuning
 Auto SQL       Auto SQL        Access
  Tuning         Analysis       Advisor       Automatic SQL
                                               Analysis
   SQL                         Indexes &
  Profile
               SQL Advice
                                  MVs         SQL Access Advisor
 Packaged       Custom          Custom
Applications   Applications   Applications

               Well-tuned
                 SQL
Oracle10G System Management –
Automatic Database Diagnostic Monitor
 Performance expert
  in a box
 Automatically
  provides database-
  wide performance
  diagnosis, including
  RAC
 Pinpoints root cause
  and non-problem
  areas
 Runs proactively
Enterprise Manager 10G Grid Control
Management that Scales to the Grid

 Central management for the complete
  platform
 Dramatically lower operations costs
 Application service level management
 Manage one or many systems with little
  incremental cost
Scalable Software Maintenance –
Discover and Analyze Configurations
 Complete inventory of all Oracle software
     –   Versions
     –   Patch levels
   Oracle product configuration details
   Search and compare configurations
   Change tracking
   Reference configurations
    Scalable Software Maintenance -
    Automated Software Cloning
     Reduce manual labor in software life-cycle
           –    From hours to minutes
     Automate mass provisioning of reference
      systems



    Select Software (and         2       Clone to
1                                        Selected
    Instances) to Clone
                                         Targets



                                     3
                                             Update
                                            Inventory
    Scalable Software Maintenance -
    Automated Patch Management
     Real-time discovery of new patches
            –   Security patch rapid deployment dramatically reduces
                vulnerabilities
     Automatic staging and application
            –   From hours to minutes
     Rolling RAC upgrade



                                   2     Determine
                                        Applicability


                                        3    Apply Patch


                                            4
                                                  Update
1   Patch Published
                                                 Inventory
              Oracle10G Manageability Features

 Infrastructure              Server Configuration              Instance Tuning                 Application Tuning
   –   Easy OracleJVM             –   Automated Storage             –   User-Initiated Buffer Cache    – SQLAccess Advisor
       Monitoring                     Management                        Flushing                       – Materialized View Tuning
   –   SYSAUX Tablespace              Configuration                 –   Database Resource Manager        API
   –                              –   Automated RAC Services            - Adaptive Consumer Group      – SQL Tuning Advisor
       Enhanced Wait Model
   –   Database Features Usage        Configuration                     Mapping                        – Enhanced SQLAccess
                                  –   Simplified Upgrade for        –   Database Resource Manager
       Tracking                                                                                          Advisor
   –   Enhanced Database Time         RAC and OPS Databases             - Fixed CPU Quota              – Automatic Optimizer
                                  –   Automated Enterprise          –   New Performance Overview
       Model                                                                                             Statistics Collection
   –                                  Manager Configuration             Charts in Oracle Enterprise
       Top Consumers
                                  –                                     Manager                      Backup and Recovery
       Performance Monitoring &       Automated Portable                                               – Enhanced RMAN Reporting
                                      Clusterware Installation      –   Improved SQL Reporting
       Diagnostic                                                                                      – Backup Compression
   –   JDBC: End-to-end           –   Automated Configuration           Using Oracle Enterprise
                                                                        Manager                        – Bounded Backup Window
       Java/J2EE Tracing              of Recovery Area
                                  –                                 –   Integration of Resource        – Manage RMAN Scripts
   –   SQLJ: End-to-end               Out-of-the-box LDAP
       Java/J2EE Tracing              Configuration                     Manager and Profiles           – Recovery Area Full Alert
                                  –                                 –   Automated Checkpoint
   –   Automated Routine              Simplified Initialization
                                                                        Tuning
                                                                                                     Storage Management
       Administration Tasks           Parameters                                                       – Multiple Default Temporary
                                  –                                 –   Transaction Rollback &
   –   Proactive Server-based         Easy Upgrade                                                       Tablespace Support for
       Alerts and Notifications   –   Upgrade Information Tool          Recovery Monitoring
                                                                                                         SQL Operations
                                                                    –   Database Performance
   –   Database Statistics and    –   Simplified Database Install                                      – Automated Storage
       Workload Respository       –
                                                                        Analyzer
                                      User Default Tablespace                                            Management
                                                                    –   Redo Logfile Sizing Advisor
   –   Threshold-Based Alerts                                                                          – Rename Tablespace
                                                                    –   Automated SGA Memory
                                                                        Tuning
             Oracle10G Manageability Features
             (continued)
 Network Management            Space, Object,             Database Utilities              Scheduler
  –   Back Up Directory Naming   Transaction Mgmt               –   SQL*Plus - SPOOL            –   Core Scheduler Features
                                 –   Automatic Undo Retention       CREATE, REPLACE, and        –   Usability and
      Entries to Local Naming
      File                           Tuning                         APPEND Options                  Manageability
                                 –                              –   SQL*Plus - Show Recycle     –
  –   Dynamic Connection             Segment Shrink Advisor                                         Monitoring
                                 –   Segment Size Estimation        Bin                         –   Recovery
      Manager Configuration                                     –
                                 –   Online Segment Shrink          SQL*Plus -                  –   Support for Jobs in a
  –   Easy Connect Naming
                                 –
                                                                    DBMS_OUTPUT After               Clustered Environment
      Method                         Proactive Tablespace           SELECT
                                     Management                                                 –   Job Processing
  –   Easy OCI/JDBC Install                                     –   SQL*Plus - SET
                                 –   Undo Advisor                                               –   ILMS Support
  –   Improved Network Outage                                       SQLPROMPT Runtime
                                                                    Variable Substitution       –   Increased Throughput
      Detection                                                                                 –
                                                                –   SQL*Plus -                      Redo Minimization
  –   Automated LDAP                                                COMPATIBILITY               –   Dynamic Slave Pool
      Discovery for Clients                                         Command Line Option
  –   Improved Connection                                       –   SQL*Plus - Run glogin.sql
      Manager Access Rules                                          and login.sql After Each
  –   Automated Shared Server                                       CONNECT
      Configuration                                             –   iSQL*Plus Input
  –   Simplified Shared Server                                      Prompting
      Configuration Parameters
Oracle Database 10G –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
Transportable Tablespaces –
Fastest Way to Provision Data

 Oracle can unplug and plug database data
  files
   –   Move and share data without unload and
       reload
   –   Plug/unplug performance independent of
       tablespace size
   –   Mount read-only tablespaces on multiple
       databases
 New: Now Works Cross-Platform!


                                   24
Oracle10G Data Pump
 High performance import and export
   –   60% faster than 9i export (single thread)
   –   15x-20x faster than 9i import (single thread)
 Scales with parallel threads
 Network transfer data between databases
  with no intermediate representation
Oracle Streams Oracle

              Oracle Streams moves or copies
                  tablespaces faster than FTP
                        Detach, move, attach
                          with one command

              Same platform or cross platform
Oracle Streams Oracle

              Oracle Streams moves or copies
                  tablespaces faster than FTP
                        Detach, move, attach
                          with one command

              Same platform or cross platform
      Oracle Streams Oracle

                              Oracle Streams moves or copies
                                  tablespaces faster than FTP
                                        Detach, move, attach
                                          with one command

                              Same platform or cross platform
Optionally stream
delta updates

Migrate to the Grid with
the self-propelled database
Oracle Database 10G–
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
Business Intelligence on the Grid

   Lower Cost
     –   Leverage 10G hardware, software, labor savings
     –   Manage millions of terabytes
   Intelligence when you need it
     –   Real-time data feeds and integrated BI capabilities
   More value from your data
     –   Additional integrated BI capabilities
Managing Large Volumes of Data

 Partitioning and parallelism are crucial for VLDB
 Partitioning provides „incremental‟ operations for:
    –   WORK SMARTER
    –   Data loading, Indexing, Referential Integrity
    –   Backup and Recovery
    –   Queries
 Parallelism for all operations
    –   WORK HARDER
    –   DBA operations: loading, index-creation, table-creation, data-
        modification, backup and recovery
    –   End-user operations: Queries
    –   Unbounded scalability: Real Application Clusters
Partitioning - Minimal Unit of Work

  Intelligent usage of partitioning information is key
   success factor for availability
     –   Partition Pruning
     –   Backup and Recovery
     –   Read-Write versus Read-Only

                           order table

          jan99    feb99     mar99       apr99   may99
   Partitioning - Rolling Window
       Partition level management
              –   Range, Composite (range + hash), List
              –   On-line addition and removal of partitions
              –   Data management operations (loading, index builds)
       Improved availability
              –   Localized disk failures, backup and recovery


                                        order table                     Add

                    jan99      feb99       mar99      apr99            may99


        Drop

Local Index




                             Other data is not affected
Table Compression
 Table Compression increases:
   –   I/O-subsystem capacity
   –   I/O throughput
   –   query scan performance
   –   buffer cache capacity
 Table Compression:
   –   reduces cost of ownership
   –   is easy to use
   –   requires little or no table definition changes
   –   is transparent to applications
   Table Compression:
   What is it?

 Tables can be compressed
    –   Compression can also be specified at the partition level
    –   Indexes and index-organized tables are not compressed
 Typical compression ratios are 3:1 - 6:1
    –   Compression is dependent upon the actual data
    –   Compression algorithm based on removing data redundancy
 All DDL/DML commands are supported on compressed
  tables
Oracle Parallel Query - Scanning

                            Data is Partitioned into
              Scanner #1     Granules (block range or
                             partition)
                            Each Scanner is Assigned
                             Multiple Granules
                            No two scanners ever
              Scanner #2     contend for the same granule
                            Granules are assigned so
                             that the Load is Balanced
                             Across all Scanners
                            Dynamic Granules
              Scanner #3


        ...
10G Real Time Warehouse
Asynchronous CDC


                        Logical                                DW
           Based on   Change Data                             Tables
Archived    Streams
   log
  files                               Transform
                                       SQL, PL/SQL,
                                          Java

                  SQL interface to change data
                  Publish/subscribe paradigm
                  Parallel access to log files, leveraging
   OLTP            Oracle Streams
    DB            Parallel transformation of data
              Oracle10G Business Intelligence
              Features
 Real Time Data               VLDB                           Summary Management                   OLAP
  Warehousing                      –   Bigfile Tablespace           –   Summary Management            –   Parallel AGGREGATE
   –   Asynchronous Change         –   Enhanced Partition               OLAP Query Performance            Command
       Data Capture                    Management in Enterprise         Improvements                  –   Parallel SQL IMPORT
   –                                   Manager                      –   Summary Management -              Command
       Cross-Platform
       Transportable               –   Global Partitioned Indexes       Enhanced Partition-aware      –   PL/SQL Creation of
       Tablespaces                     - Hash Partitioning              Materialized View Refresh         Analytic Workspaces
   –                               –                                –   Summary Management -          –
       Enhanced Table                  Partitioned Index-                                                 Intra-Dimensional
       Functions                       Organized Tables - List          EXPLAIN PLAN Shows                (Attribute) Aggregation
   –   External Tables Unload          Partitioning                     Materialized View Access      –   Enhanced Composite
                                   –                                –   Summary Management -
   –   Enhanced MERGE                  Partitioned Index-                                                 Dimensions Indexing
       Functionality                   Organized Tables - LOB           Enhanced Dimensions           –   PL/SQL OLAP Measure
                                       Support                      –   Summary Management -
   –   Data Pump Export and                                                                               Calculation Definition
       Import Utilities            –   Partitioned Index-               Nested Materialized View      –   Complete Analytical
   –                                   Organized Tables - Global        Refresh                           Workspace Management
       Parallel Data Pump Export                                    –
       and Import                      Index Maintenance                Summary Management -          –   Multi-Writer Support
   –
                                   –   Enhanced Bitmap Index            Enhanced PCT Refresh          –
       SQL*Loader Direct Path                                       –                                     XML Interface for Analytic
       Load Support for ROWID          Performance and Space            Summary Management -              Workspace
       Datatype                        Management                       Query Rewrite Uses
   –
                                   –   Local Partitioned Indexes        Multiple Materialized
       SQL*Loader Direct Path
       Load Support for VARRAY         Manageability
       Datatype                        Improvements
   –   SQL*Loader Direct Path
       Load Support for
       XMLType Tables
              Oracle10G Business Intelligence
              Features (Continued)
 Data Mining                 Bio-informatics
   –                             – DOUBLE and FLOAT
       Frequent Itemsets
   –                               Datatypes
       Attribute Importance      – BLAST Queries
       Algorithms
                                 – Statistical Functions
   –   Enhanced Adaptive Bayes –
       Network                     Document Clustering
                                 – Document Clustering Non-
   –   JSR-73 RI & TCK - Java      negative Matrix
       Data Mining                 Factorization
   –   Multi-User Access Control – Document Clustering
   –   Complete Oracle Data        Neural Nets
       Mining Management         – Document Named Entity
   –   Enhanced Model Seeker       Extraction
                                 – Support Vector Machines
   –   PMML Producers /
                                 – Taxonomy Builder
       Consumers
   –   Enhanced Data           SQL Analytics
       Preprocessing             – Grouped Table Outer Join

   –                             – Increased Number of
       Data Mining Rapid
       Application Development     Aggregates per Query
                                 – SQL Interrow Calculations
                                 – Upsert Through SQL
                                   Interrow Calculations
Oracle Database 10G –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
Application Development on the Grid

 HTML DB
   –   Low Cost, Hosted,
       Web Based
       Development
       Environment
 Improved PL/SQL
  Performance
 Database Web
  Services
HTML DB and the Grid - Business
Problem
 Departmental and
  LOB data sharing and
  information tracking
 Lots and lots of
  desktop databases
 Fragmented
 Inaccurate
 Untimely
 Vulnerable
HTML DB – Perfect for the Grid

  Productivity of a
   Desktop Database
  Infrastructure of an
   Enterprise Database
  Built for the Web
  Leverages the Grid
Oracle Database 10G –
Database for the Grid

   Storage for All Your Data
   Real Application Clusters
   High Availability
   Ease of Management
   Data Provisioning across Grid
   Business Intelligence on the Grid
   Application Development on the Grid
Oracle Database 10G
 Half the Cost
   –   Low cost hardware with high utilization
   –   Integrated software stack
   –   Self-managing
 Highest Quality of Service
   –   Highest Performance, Scalability,
       Availability, Reliability, Security
 Easy to Align with Business Priorities
Oracle Database 10g Performance
Metrics
 PLSQL up to 2x            Incremental backup up 10x
 Table Scans up to 2x      Parallel media recovery
 SQL Profile Tuning         2-4x
  huge                      Backup compression 17x
 Floating point math up    Infiniband interconnect
  to 10x                     ½ latency, 2x block
                             transfer
 Bulk LOB Update up to
                            TPC-C
  3x                          –   Best absolute and best on 4-
 Import up to 15x                way Intel
                              –   +28% on same hardware
 Export up to 35%
Q U E S T I O N S
 A N S W E R S

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:33
posted:11/13/2011
language:English
pages:99