• Oracle Database 11g: New Features for Administrato
  Oracle Database 11g: New Features for Administrators DBA Release 2 (11gR2-DB-NF)培訓
  培訓大綱：
  1. Oracle Grid Infrastructure
  Installing Oracle Grid Infrastructure for a Standalone Server
  Creating an ASM Disk Group
  ASM Cluster File System
  ASM Dynamic Volume Manager
  ASM File System Snapshot
  2. Installation and Upgrade Enhancements
  Installing Oracle Database 11g Release 2
  Oracle Database Upgrade Enhancements
  Online Patching
  Upgrading Your Time Zone File and Timestamp with Time Zone Data
  3. Oracle Restart
  Controlling Oracle Restart
  Using the srvctl Utility
  Manually Adding Components to the Oracle Restart Configuration
  4. ASM Enhancements
  Setting up ASM Fast Mirror Resync
  Using ASM Scalability and Performance Enhancements
  ASM Disk Group Compatibility
  Using ASMCMD Extensions
  ASM File Access Control
  ASM Optimal Disk Placement
  5. Storage Enhancements
  Using 4 KB-Sector Disks
  Using Table Compression
  Hybrid Columnar Compression
  SQL Access Advisor
  Segment Creation on Demand
  6. Data Warehouse and Partitioning Enhancements
  Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
  Degree of Parallelism Enhancements
  In-Memory Parallel Query
  Partitioning Enhancements
  System-Managed Indexes for List Partitioning
  7. Oracle SecureFiles
  Enabling SecureFiles Storage
  Creating SecureFiles
  Using SecureFiles Compression
  Accessing SecureFiles Metadata
  Migrating to SecureFiles
  8. Security and Networking Enhancements
  Secure Password Support
  Automatic Secure Configuration
  Managing Default Audits
  Setting Database Administrator Authentication
  Transparent Data Encryption
  Hardware Security Module
  Tablespace Master Key Re-Key
  Supporting IPv6 Address Notification
  9. SQL Performance Analyzer
  Using SQL Performance Analyzer
  Using Enterprise Manager to Access SQL Performance Analyzer
  SQL Performance Analyzer: PL/SQL Example
  SQL Performance Analyzer: Data Dictionary Views
  10. SQL Plan Management
  Overview
  Loading SQL Plan Baselines
  Using the MIGRATE_STORED_OUTLINE Functions
  Viewing Important Baseline SQL Plan Attributes
  Loading a SQL Plan Baseline Automatically
  Purging SQL Management Base Policy
  11. Database Replay
  Using Database Replay
  Database Replay System Architecture
  Supported Workloads
  Database Replay Workflow in Enterprise Manager
  Database Replay PL/SQL Procedures
  Database Replay Data Dictionary Views
  12. Automatic SQL Tuning
  Automatic SQL Tuning in Oracle Database 11g
  Selecting Potential SQL Statements for Tuning
  Controlling the Automatic SQL Tuning Task
  Configuring Automatic SQL Tuning
  Using the PL/SQL Interface to Generate Reports
  13. Intelligent Infrastructure Enhancements
  Using New Automatic Workload Repository Views
  Creating AWR Baselines
  Alert Thresholds Using Static Baseline
  Controlling Automatic Maintenance Tasks
  Fixed Policy and CPU Resource Management
  Instance Caging
  Scheduler Enhancements
  14. Diagnosability Enhancements
  Setting Up Automatic Diagnostic Repository
  ADRCI: The ADR Command-Line Tool
  Incident Packaging Service (IPS)
  Using the Enterprise Manager Support Workbench
  Invoking IPS Using ADRCI
  Running Health Checks Manually
  Using the SQL Repair Advisor
  15. SQL Monitoring
  SQL Monitoring in Oracle Database 11g Release 2
  Viewing Session Details
  Viewing the SQL Monitoring Report
  16. Performance Enhancements
  Using the DBMS_ADDM Package
  New and Modified Views
  Enabling Automatic Memory Management
  Using New Statistic Preferences Features
  Locking Enhancements
  Adaptive Cursor Sharing
  Using Table Annotation to Control Result Caching
  17. Application Maintenance and Upgrade Enhancements
  Online Redefinition Enhancements
  Creating and Using Invisible Indexes
  18. Backup and Recovery Enhancements
  Using New SET NEWNAME Clauses
  Optimized Backups
  Using New Settings for Binary Compression
  Enhancements to Database Duplication
  Creating Archival Backups
  TSPITR Enhancements and Modifications
  Creating and Using Virtual Private Catalogs
  Introduction to Oracle Secure Backup Cloud Module
  19. Flashback Technology, LogMiner, and Data Pump
  Oracle Total Recall
  Flashback Transaction Backout
  Enterprise Manager LogMiner Interface
  Data Pump Legacy Mode
  20. Data Recovery Advisor
  Assessing Data Failures
  Data Recovery Advisor RMAN Command-Line Interface
  Data Recovery Advisor Views
  Setting Parameters to Detect Corruption
  ?
  ?
  ?
  ?
• 
  ?
• 
  ?
• 
  ?
  ?
  ?
  ?
• 
  ?
  ?

?
?

?

?

?

?

?
?

?
?

?

?

?

?
???

?

?
?

?

?