1 / 55

Thomas Kyte thomas.kyte@oracle Oracle Corporation asktom.oracle

Thomas Kyte thomas.kyte@oracle.com Oracle Corporation http://asktom.oracle.com. Resources. metalink.oracle.com asktom.oracle.com otn.oracle.com Discussion forums Software download Documentation Technology Corners www.oracle.com/oramag groups.google.com comp.databases.oracle.* IOUG.

temple
Download Presentation

Thomas Kyte thomas.kyte@oracle Oracle Corporation asktom.oracle

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Thomas Kyte thomas.kyte@oracle.com Oracle Corporation http://asktom.oracle.com

  2. Resources • metalink.oracle.com • asktom.oracle.com • otn.oracle.com • Discussion forums • Software download • Documentation • Technology Corners • www.oracle.com/oramag • groups.google.com • comp.databases.oracle.* • IOUG

  3. 10G 10G Introducing Oracle 10g • Runs all your applications • Stores all your information • Highly • Scalable • Available • Reliable • Secure • Easy to manage • Make individual systems self-managing • Manage many servers at once Disclaimer

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

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

  6. Oracle Database 10g – Align Storage with the Business • Problem: Islands of storage • “My storage is 50% utilized and growing 30% a year” CRM ERP DW

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

  8. Oracle Grid Storage ManagementHighly 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 • Flashback in Time • Site Recovery Automatic Storage Management Disk Based Backup & Recovery

  9. RelationalCharacters, Numbers and Dates Oracle TextText management and search Oracle interMediaMultimedia management Oracle LocatorLocation and Proximity Searching XML DBIntegrated Native XML Database OCS FilesLow-cost and Easy 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

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

  11. Align Processing with the Business • Problem: Islands of computation • “My servers are 15% utilized“ CRM ERP DW

  12. 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 ERP CRM DW

  13. Services Framework Cluster Control/Recovery Messaging and Locking Connectivity Complete, Integrated Clusterware • Complete Oracle cluster software solution • Single-vendor support • Low Cost • No need to purchase additional software • Easy to install, manage • High quality and functionality across all platforms • Common event and management API’s • Multi-tier HA & minimal MTTR • Support for third-party clusterware

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

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

  16. Low Cost Fault Tolerance Computer Failures UnplannedDowntime Data Failures System Changes PlannedDowntime Data Changes

  17. Low Cost Fault Tolerance Oracle10g RAC • Integrated clusterware • Integrated, less moving parts, better tested • Faster failover between servers • Single digit seconds Computer Failures UnplannedDowntime Data Failures System Changes PlannedDowntime Data Changes

  18. New Economics forData Protection & Recovery Computer Failures Disk-Based Recovery UnplannedDowntime Data Failures Trade cheap disk space for expensive downtime System Changes PlannedDowntime Lets take a look Data Changes

  19. Flashback Database • New strategy for point-in-time recovery • Flashback Log captures old versions of changed blocks • Think of it as a continuous backup • Replay log to restore DB to time • Restores just changed blocks • It’s fast - recovers in minutes, not hours • It’s easy - single command restore • SQL> Flashback Database to ‘2:05 PM’ Old Block Version Disk Write New Block Version Flashback Log Like a “Rewind” button for the Database

  20. Nightly Applyof IncrementalBackup WeeklyArchive toTape Flash Backup • Fully automatic disk-based backup and recovery • Set and Forget • Nightly incremental backup rolls forward recovery area backup • Changed blocks are tracked in production DB • Full scan is never needed • Dramatically faster • Use low cost ATA disk array for recovery area Database Area Recovery Area Tape

  21. And yet more Flashback • Flashback Database • Flashback Table • Put table and related segments back as they was • Flashback Row History • Show me the values of this row for the last three hours • Also great for optimistic concurrency control on the web • Flashback Drop • Undrop that table • Flashback Transaction History • Undo transaction xxx.yyy.zzz

  22. No Cost System Changes • GOAL: Allow any change to the system with no downtime Computer Failures UnplannedDowntime Data Failures System Changes Online Reconfiguration PlannedDowntime Rolling Upgrades Data Changes

  23. Data Guard Redo Shipping Site FailureProtection, rolling upgrades Flash Backup On Disk Backups Flashback Corruption Protection Flashback Logs Human Error Protection ASM Mirroring Storage FailureProtection Oracle Database 10g Highest Data Protection for Lowest Cost

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

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

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

  27. Creation & Configuration 12 % Business Challenge – How to Scale DBA’s to the Grid ? Installation 6% Others 15% DataLoading 6% Software Maintenance 6% Ongoing System Management 55% Source: IOUG 2001 DBA Survey

  28. Automatic Workload Repository Automatically collects statistics, SQL workload, Feature usage Base-lining capability History Automatic Maintenance Tasks Pre-packaged, resource controlled Server-Generated Alerts Out-of-the-box, Push vs. Pull, Just-in-time Oracle10i System Management – Built-In Intelligent Infrastructure

  29. Buffer Cache Online Users Large Batch Jobs Large Pool Buffer Cache Large Pool SQL Cache SQL Cache SGA Pool Java Pool Java Pool sort sort PGA Pool Oracle10i System Management – Automatic SGA Management • Only 2 memory parameters • Advisor helpsset parameters • Automatically resizes with changes in workload • Maximize usage of available memory

  30. Oracle10i System Management – Self Optimizing SQL Management • Oracle Query Optimizer • 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

  31. PackagedApps CustomApps High-load SQL Automatic Tuning Optimizer Auto SQL Tuning Auto SQL Analysis Access Advisor PackagedApps + CustomApps + CustomApps + SQLProfile SQLAdvice Indexes & MVs Well-tuned SQL Oracle10i System Management – Self Optimizing SQL Management • Automated capture and identification of high-load SQL • Automatic SQL Tuning • Automatic SQL Analysis • SQL Access Advisor

  32. Oracle10g System Management – Automatic Database Diagnostic Monitor (ADDM) • Performance expert in a box • Automatically provides database-wide performance diagnosis, including RAC • Pinpoints root cause and non-problem areas • Runs proactively

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

  34. Select Software (and Instances) to Clone 1 2 Clone to Selected Targets Scalable Software Maintenance - Automated Software Cloning • Reduce manual labor in software life-cycle • From hours to minutes • Automate mass provisioning of reference systems 3 Update Inventory

  35. 3 Apply Patch 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 4 Update Inventory 1 Patch Published

  36. Infrastructure Easy OracleJVM Monitoring SYSAUX Tablespace Enhanced Wait Model Database Features Usage Tracking Enhanced Database Time Model Top Consumers Performance Monitoring & Diagnostic JDBC: End-to-end Java/J2EE Tracing SQLJ: End-to-end Java/J2EE Tracing Automated Routine Administration Tasks Proactive Server-based Alerts and Notifications Database Statistics and Workload Respository Threshold-Based Alerts Oracle10g Manageability Features • Server Configuration • Automated Storage Management Configuration • Automated RAC Services Configuration • Simplified Upgrade for RAC and OPS Databases • Automated Enterprise Manager Configuration • Automated Portable Clusterware Installation • Automated Configuration of Recovery Area • Out-of-the-box LDAP Configuration • Simplified Initialization Parameters • Easy Upgrade • Upgrade Information Tool • Simplified Database Install • User Default Tablespace • Instance Tuning • User-Initiated Buffer Cache Flushing • Database Resource Manager - Adaptive Consumer Group Mapping • Database Resource Manager - Fixed CPU Quota • New Performance Overview Charts in Oracle Enterprise Manager • Improved SQL Reporting Using Oracle Enterprise Manager • Integration of Resource Manager and Profiles • Automated Checkpoint Tuning • Transaction Rollback & Recovery Monitoring • Database Performance Analyzer • Redo Logfile Sizing Advisor • Automated SGA Memory Tuning • Application Tuning • SQLAccess Advisor • Materialized View Tuning API • SQL Tuning Advisor • Enhanced SQLAccess Advisor • Automatic Optimizer Statistics Collection • Backup and Recovery • Enhanced RMAN Reporting • Backup Compression • Bounded Backup Window • Manage RMAN Scripts • Recovery Area Full Alert • Storage Management • Multiple Default Temporary Tablespace Support for SQL Operations • Automated Storage Management • Rename Tablespace

  37. Infrastructure Easy OracleJVM Monitoring SYSAUX Tablespace Enhanced Wait Model Database Features Usage Tracking Enhanced Database Time Model Top Consumers Performance Monitoring & Diagnostic JDBC: End-to-end Java/J2EE Tracing SQLJ: End-to-end Java/J2EE Tracing Automated Routine Administration Tasks Proactive Server-based Alerts and Notifications Database Statistics and Workload Respository Threshold-Based Alerts Oracle10g Manageability Features • Server Configuration • Automated Storage Management Configuration • Automated RAC Services Configuration • Simplified Upgrade for RAC and OPS Databases • Automated Enterprise Manager Configuration • Automated Portable Clusterware Installation • Automated Configuration of Recovery Area • Out-of-the-box LDAP Configuration • Simplified Initialization Parameters • Easy Upgrade • Upgrade Information Tool • Simplified Database Install • User Default Tablespace • Instance Tuning • User-Initiated Buffer Cache Flushing • Database Resource Manager - Adaptive Consumer Group Mapping • Database Resource Manager - Fixed CPU Quota • New Performance Overview Charts in Oracle Enterprise Manager • Improved SQL Reporting Using Oracle Enterprise Manager • Integration of Resource Manager and Profiles • Automated Checkpoint Tuning • Transaction Rollback & Recovery Monitoring • Database Performance Analyzer • Redo Logfile Sizing Advisor • Automated SGA Memory Tuning • Application Tuning • SQLAccess Advisor • Materialized View Tuning API • SQL Tuning Advisor • Enhanced SQLAccess Advisor • Automatic Optimizer Statistics Collection • Backup and Recovery • Enhanced RMAN Reporting • Backup Compression • Bounded Backup Window • Manage RMAN Scripts • Recovery Area Full Alert • Storage Management • Multiple Default Temporary Tablespace Support for SQL Operations • Automated Storage Management • Rename Tablespace

  38. Network Management Back Up Directory Naming Entries to Local Naming File Dynamic Connection Manager Configuration Easy Connect Naming Method Easy OCI/JDBC Install Improved Network Outage Detection Automated LDAP Discovery for Clients Improved Connection Manager Access Rules Automated Shared Server Configuration Simplified Shared Server Configuration Parameters Oracle10g Manageability Features(continued) • Space, Object, Transaction Mgmt • Automatic Undo Retention Tuning • Segment Shrink Advisor • Segment Size Estimation • Online Segment Shrink • Proactive Tablespace Management • Undo Advisor • Database Utilities • SQL*Plus - SPOOL CREATE, REPLACE, and APPEND Options • SQL*Plus - Show Recycle Bin • SQL*Plus - DBMS_OUTPUT After SELECT • SQL*Plus - SET SQLPROMPT Runtime Variable Substitution • SQL*Plus -COMPATIBILITY Command Line Option • SQL*Plus - Run glogin.sql and login.sql After Each CONNECT • iSQL*Plus Input Prompting • Scheduler • Core Scheduler Features • Usability and Manageability • Monitoring • Recovery • Support for Jobs in a Clustered Environment • Job Processing • ILMS Support • Increased Throughput • Redo Minimization • Dynamic Slave Pool

  39. Network Management Back Up Directory Naming Entries to Local Naming File Dynamic Connection Manager Configuration Easy Connect Naming Method Easy OCI/JDBC Install Improved Network Outage Detection Automated LDAP Discovery for Clients Improved Connection Manager Access Rules Automated Shared Server Configuration Simplified Shared Server Configuration Parameters Oracle10g Manageability Features(continued) • Space, Object, Transaction Mgmt • Automatic Undo Retention Tuning • Segment Shrink Advisor • Segment Size Estimation • Online Segment Shrink • Proactive Tablespace Management • Undo Advisor • Database Utilities • SQL*Plus - SPOOL CREATE, REPLACE, and APPEND Options • SQL*Plus - Show Recycle Bin • SQL*Plus - DBMS_OUTPUT After SELECT • SQL*Plus - SET SQLPROMPT Runtime Variable Substitution • SQL*Plus -COMPATIBILITY Command Line Option • SQL*Plus - Run glogin.sql and login.sql After Each CONNECT • iSQL*Plus Input Prompting • Scheduler • Core Scheduler Features • Usability and Manageability • Monitoring • Recovery • Support for Jobs in a Clustered Environment • Job Processing • ILMS Support • Increased Throughput • Redo Minimization • Dynamic Slave Pool

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

  41. 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 • Now Works Cross-Platform! 24

  42. 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 • Eg: no disk

  43. Oracle Streams Oracle Oracle Streams moves or copiestablespaces faster than FTP Detach, move, attachwith one command Same platform or cross platform

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

  45. DW Tables Logical Change Data Based on Streams Transform SQL, PL/SQL,Java 10g Real Time Warehouse Asynchronous CDC • SQL interface to change data • Publish/subscribe paradigm • Parallel access to log files, leveraging Oracle Streams • Parallel transformation of data Archived log files OLTP DB

  46. Real Time Data Warehousing Asynchronous Change Data Capture Cross-Platform Transportable Tablespaces Enhanced Table Functions External Tables Unload Enhanced MERGE Functionality Data Pump Export and Import Utilities Parallel Data Pump Export and Import SQL*Loader Direct Path Load Support for ROWID Datatype SQL*Loader Direct Path Load Support for VARRAY Datatype SQL*Loader Direct Path Load Support for XMLType Tables Oracle10g Business Intelligence Features • VLDB • Bigfile Tablespace • Enhanced Partition Management in Enterprise Manager • Global Partitioned Indexes - Hash Partitioning • Partitioned Index-Organized Tables - List Partitioning • Partitioned Index-Organized Tables - LOB Support • Partitioned Index-Organized Tables - Global Index Maintenance • Enhanced Bitmap Index Performance and Space Management • Local Partitioned Indexes Manageability Improvements • Summary Management • Summary Management OLAP Query Performance Improvements • Summary Management - Enhanced Partition-aware Materialized View Refresh • Summary Management - EXPLAIN PLAN Shows Materialized View Access • Summary Management - Enhanced Dimensions • Summary Management - Nested Materialized View Refresh • Summary Management - Enhanced PCT Refresh • Summary Management - Query Rewrite Uses Multiple Materialized Views • OLAP • Parallel AGGREGATE Command • Parallel SQL IMPORT Command • PL/SQL Creation of Analytic Workspaces • Intra-Dimensional (Attribute) Aggregation • Enhanced Composite Dimensions Indexing • PL/SQL OLAP Measure Calculation Definition • Complete Analytical Workspace Management • Multi-Writer Support • XML Interface for Analytic Workspace

  47. Real Time Data Warehousing Asynchronous Change Data Capture Cross-Platform Transportable Tablespaces Enhanced Table Functions External Tables Unload Enhanced MERGE Functionality Data Pump Export and Import Utilities Parallel Data Pump Export and Import SQL*Loader Direct Path Load Support for ROWID Datatype SQL*Loader Direct Path Load Support for VARRAY Datatype SQL*Loader Direct Path Load Support for XMLType Tables Oracle10g Business Intelligence Features • VLDB • Bigfile Tablespace • Enhanced Partition Management in Enterprise Manager • Global Partitioned Indexes - Hash Partitioning • Partitioned Index-Organized Tables - List Partitioning • Partitioned Index-Organized Tables - LOB Support • Partitioned Index-Organized Tables - Global Index Maintenance • Enhanced Bitmap Index Performance and Space Management • Local Partitioned Indexes Manageability Improvements • Summary Management • Summary Management OLAP Query Performance Improvements • Summary Management - Enhanced Partition-aware Materialized View Refresh • Summary Management - EXPLAIN PLAN Shows Materialized View Access • Summary Management - Enhanced Dimensions • Summary Management - Nested Materialized View Refresh • Summary Management - Enhanced PCT Refresh • Summary Management - Query Rewrite Uses Multiple Materialized Views • OLAP • Parallel AGGREGATE Command • Parallel SQL IMPORT Command • PL/SQL Creation of Analytic Workspaces • Intra-Dimensional (Attribute) Aggregation • Enhanced Composite Dimensions Indexing • PL/SQL OLAP Measure Calculation Definition • Complete Analytical Workspace Management • Multi-Writer Support • XML Interface for Analytic Workspace

  48. Data Mining Frequent Itemsets Attribute Importance Algorithms Enhanced Adaptive Bayes Network JSR-73 RI & TCK - Java Data Mining Multi-User Access Control Complete Oracle Data Mining Management Enhanced Model Seeker PMML Producers / Consumers Enhanced Data Preprocessing Data Mining Rapid Application Development Oracle10g Business Intelligence Features (Continued) • Bio-informatics • DOUBLE and FLOAT Datatypes • BLAST Queries • Statistical Functions • Document Clustering • Document Clustering Non-negative Matrix Factorization • Document Clustering Neural Nets • Document Named Entity Extraction • Support Vector Machines • Taxonomy Builder • SQL Analytics • Grouped Table Outer Join • Increased Number of Aggregates per Query • SQL Interrow Calculations • Upsert Through SQL Interrow Calculations

  49. Data Mining Frequent Itemsets Attribute Importance Algorithms Enhanced Adaptive Bayes Network JSR-73 RI & TCK - Java Data Mining Multi-User Access Control Complete Oracle Data Mining Management Enhanced Model Seeker PMML Producers / Consumers Enhanced Data Preprocessing Data Mining Rapid Application Development Oracle10g Business Intelligence Features (Continued) • Bio-informatics • DOUBLE and FLOAT Datatypes • BLAST Queries • Statistical Functions • Document Clustering • Document Clustering Non-negative Matrix Factorization • Document Clustering Neural Nets • Document Named Entity Extraction • Support Vector Machines • Taxonomy Builder • SQL Analytics • Grouped Table Outer Join • Increased Number of Aggregates per Query • SQL Interrow Calculations • Upsert Through SQL Interrow Calculations

More Related