New London College
1 Martindale Road, Hounslow West, Middlesex,TW4 7EW
Tel: 020 85707766 Fax:020 85770199
Email: info@newlondoncollege.co.uk
For Enroll Call
020 85707766
|
New London College |
For Enroll Call |
|
|
|
Course Information Oracle Database 10g: New Features OverviewCourse Type : Part Time Course Starting dates
This course will give participants an overview of various new features and enhancements included in Oracle Database 10g, the latest release of the Oracle Database. The seminar lessons cover the following focus areas: Manageability, High Availability, Performance, Development Platform, and Business Intelligence and Data Warehousing Upon completion of this class, participants will be given extra lab time to prepare them to successfully pass the Oracle certification exam. Who should attend: This course is valuable for programmers,sales consultants, Technical consultants, database administrators and support engineers. Prerequisites: Administration experience with Oracle Databases . Course Objectives: Appreciate the new common manageability infrastructure Describe the storage and space enhancements Describe the new data pump architecture and its export and import clients Identify various flashback enhancements to correct human errors Appreciate the backup and recovery enhancements Explain the various performance enhancements List the most important SQL and PL/SQL enhancements Describe the business intelligence and data warehousing enhancements Course Topics:Common Manageability Infrastructure Automatic Workload Repository (AWR) Active Session History (ASH) AWR Snapshot Baselines Server-generated Alerts Automated Tasks Advisory Framework Performance Management New Monitoring Solutions Automatic Database Diagnostic Monitor (ADDM) SQL Tuning Advisor SQL Access Advisor Resource Management Automatic Shared Memory Management Automatic Session Switch Back Idle Time-outs for Consumer Groups Session to Consumer Group Mappings Space Management Proactive Tablespace Monitoring Segment Advisor Automatic Undo Management Enhancements Undo Advisor Resumable Space Allocation Redo Logfile Size Advisor Storage Enhancements SYSAUX Tablespace Automatic Storage Management (ASM) Temporary Tablespace Groups Bigfile Tablespaces Transportable Tablespace Enhancements Data Management Data Pump Overview Data Pump Export and Import External Table Enhancements Human Error Correction Flashback Versions Query Flashback Transaction Query Flashback Table Flashback Drop Flashback Database Flash Recovery Area Backup and Recovery Enhancements Simplified Recovery Through Resetlogs RMAN Command and Script Enhancements Compressed Backup Sets Fast Recovery Flash Backup and Recovery Drop Database Disaster Recovery Enhancements Data Guard Real Time Apply Role-Based Archive Logfile Destinations Redo Shipment: Authentication and Encryption Flashback Database in a Standby Configuration Zero Downtime Instantiation Online Redefinition Enhancements Log Miner Enhancements Performance Enhancements Sorted Hash-Clustered Tables End-to-end Application Tracing Automatic Statistics Collection SQL, PL/SQL, and SQL*Plus Native Floating-Point Data Types Multiset Operators MERGE Command Enhancements Interrow Calculations with the MODEL Clause Regular Expressions Supplied PL/SQL Packages DBMS_WM UTL_MAIL UTL_COMPRESS DBMS_METADATA DBMS_SCHEDULER Business Intelligence and Data Warehousing Asynchronous Change Data Capture Partitioning Enhancements Materialized View Fast Refresh Query Rewrite Enhancements Return to top |
|
||||||||||||||||||||||||||||||||
