Tento kurz seznamuje účastníky s novými vlastnostmi databázového serveru Oracle Database 10g z pohledu správce databáze. Jsou vybrána zejména témata týkající se zlepšení dostupnosti databáze, zjednodušení správy databázových komponent a nových postupů při monitorování a ladění databáze. Posluchači se seznámí s možnostmi zjednodušené správy databáze s použitím podpůrných nástrojů, které se staly součástí databázového serveru. Rámcově budou probrány změny týkající se vývoje a ladění aplikací. Veškerou probíranou látku si posluchači průběžně ověřují pomocí připravených cvičení.
Předpoklady
Administration experience with Oracle9i Database
Cíle kurzu
Increase data availability through Oracle Database 10g features that offer improved point in time recovery
Utilize database advisors to provide proactive database monitoring
Implement improved manageability features to simplify database management
Assist developers using Oracle Database 10g features in their applications
Témata kurzu
Introduction
How DBAs Spend Their Time
Oracle Database 10g Manageability Goals
Oracle Database 10g Solution: Self-Managing Database
Grid Computing
Oracle Database 10g: The Database for the Grid
Installation
Installation Performance Enhancements
Installation New Feature Support
Automatic pre & post install validations
CD pack contents
Server Configuration
Database Features Usage Tracking
Automatic Enterprise Manager Configuration
Simplified Initialization Parameters
Simplified Database Install
Load and Unload Data
Cross-platform Transportable Tablespaces
External Tables Unload
DataPump Export and Import Utilities
Automatic Management
Automatic Checkpoint Tuning
Automatic Database Diagnostic Monitor
Automatic Shared Memory Tuning
Automatic Optimizer Statistics Collection
Automatic Undo Retention
Manageability Infrastructure
Advisory Framework
Automatic Routine Administration Tasks
Server-generated Alerts / Threshold-based Alerts
Automatic Workload Repository
Application Management and Availability
SQL Access Advisor
SQL Tuning Advisor
New performance overview charts in EM
Rule-based optimization (RBO) obsolescence
SQL Support for Analytical Applications
MERGE Command Enhancements
Partitioned Outer Join
Integrating Interrow Calculations in SQL
Summary Management Enhancements
System Resource Management
Setting Idle Timeouts
Switching Back to the Initial Consumer Group at End of Call
Database Resource Manager - Adaptive Consumer Group Mapping
Monitoring the Resource Manager
The Scheduler
Core Scheduler Features
Privileges for Scheduler Components
Calendaring Expressions
Advanced Scheduler Concepts
Space Management
Segment Advisor
New Segment Resource Estimation
Online Segment Shrink
Proactive Tablespace Management
Undo Advisor
Sorted Hash Clusters
Improved VLDB Support
Bigfile Tablespace
Enhanced Partition Management in Enterprise Manager
Global Partitioned Indexes - Hash Partitioning
Local Partitioned Indexes Manageability Improvements
Temporary tablespace groups
RMAN Enhancements
Flash Backup and Recovery
Backup Compression
Drop Database
Automatic Channel Failover for Backup & Restore
Incrementally Updated Backups
Simplified Recovery Through Resetlogs
Flashback Any Error
Flashback Database
Flashback Table
Flashback Versions Query
Flashback Transaction Query
Flashback Drop
General Storage Management
Rename Tablespace
Redo Logfile Sizing Advisor
SYSAUX Tablespace
Copying Files using the Database Server
Automatic Storage Management
Data mirroring with ASM
ASM Dynamic Rebalancing
ASM Striping
ASM General Architecture
ASM Disk Groups
Failure Groups
Maintain Software
Oracle Database 10g Upgrade Paths
Easy Upgrade (key DBUA features / one script upgrade)
Upgrade Information Tools (pre/post)
Security Enhancements
VPD Static and Dynamic Policies
Column-level VPD
Uniform Audit Trail
Miscellaneous New Features
Transaction Monitoring
End-to-End Tracing
Logminer Enhancements
Resumable Space Allocation Enhancements
Regular Expression functions
Resumable Space Allocation Enhancements
