Oracle Database 10g New Features For Administrators

This course presents an overview of the manageability features and enhancements included in Oracle Database 10g, the new release of the Oracle Database. Although this seminar will not give an exhaustive overview of all new features of the Oracle Database 10g, manageability is definitely the most important focus area of this new release, and probably the most interesting one for database administrators.

• Get a first impression of the most important new features in Oracle Database 10g
• 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

Target audience

Database Administrators, Technical Consultants, and Technical Support Professionals. Students should have attended the following courses or have equivalent knowledge and/or experience:

• Oracle Database 10g Introduction to SQL
• Oracle Database 10g: Program With PL/SQL
• Oracle Database 10g: Administration I
• Oracle Database 10g: Administration II
• Oracle Database 10g: PL/SQL Application Tuning

Course content

SERVER CONFIGURATION SIMPLIFIED DATABASE INSTALL • AUTOMATIC ENTERPRISE MANAGEMENT CONFIGURATION • SIMPLIFIED INITIALIZATION PARAMETERS

LOAD AND UNLOAD DATA CROSS-PLATFORM TRANSPORTABLE TABLESPACES • DATA PUMP EXPORT AND IMPORT UTILITIES • EXTERNAL TABLES

AUTOMATIC MANAGEMENT AUTOMATIC CHECKPOINT TUNING • AUTOMATIC DATABASE DIAGNOSTIC MONITOR • AUTOMATIC SHARED MEMORY MANAGEMENT • AUTOMATIC OPTIMIZER STATISTICS COLLECTION • AUTOMATIC UNDO RETENTION

AUTOMATIC MANAGEMENT ADVISORY FRAMEWORK • AUTOMATIC ROUTINE ADMINISTRATION TASKS • SERVER GENERATED ALERTS • AUTOMATIC WORKLOAD REPOSITORY

APPLICATION MANAGEMENT AND AVAILABILITY SQL ACCESS ADVISOR • SQL TUNING ADVISOR • DBMS_SQLTUNE • NEW PERFORMANCE OVERVIEW CHARTS IN DATABASE CONTROL • RULE BASED OBSOLESCENCE

SQL SUPPORT FOR ANALYTICAL APPLICATIONS MERGE COMMAND ENHANCEMENTS • PARTITIONED OUTER JOIN • INTEGRATING INTERROW CALCULATIONS IN SQL

SYSTEM RESOURCE MANAGEMENT SETTING IDLE TIMEOUTS • SWITCHING BACK TO INITIAL CONSUMER GROUP AT END OF CALL • CREATING MAPPINGS WITH DATABASE RESOURCE MANAGER • CPU_MTH=>RUN-TO-COMPLETION • CPU_MTH=> RATIO • MONITORING THE RESOURCE MANAGER

THE SCHEDULER CORE SCHEDULER FEATURES • PRIVILEGES FOR SCHEDULER COMPONENTS • CREATING A SCHEDULER JOB • ADVANCED SCHEDULER CONCEPTS • DBA_SCHEDULER_JOB_LOG • DBA_SCHEDULER_ JOBS

SPACE MANAGEMENT SEGMENT ADVISOR • SEGMENT RESOURCE ESTIMATION • ONLINE SEGMENT SHRINK • PROACTIVE TABLESPACE MANAGEMENT • UNDO ADVISOR • SORTED HASH CLUSTERS

IMPROVED VLDB SUPPORT BIGFILE TABLESPACES • ENHANCED PARTITION MANAGEMENT USING DATABASE CONTROL • HASH-PARTITIONED GLOBAL INDEXES • LOCAL PARTITIONED INDEXES • TEMPORARY TABLESPACE GROUPS

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today