Course Objectives

- Oracle Database 10g: “g” Stands for Grid 1-6 Oracle Database Architecture 1-8.
- 2 Installing the Oracle Database Software Objectives 2-2.
- Tasks of an Oracle Database Administrator 2-3 Tools Used to Administer an Oracle Database 2-4 Installation: System Requirements 2-6.
- Practice Overview: Installing the Oracle Software 2-21.
- 3 Creating an Oracle Database Objectives 3-2.
- Database Configuration Assistant (DBCA) 3-5 Using the DBCA to Create a Database 3-6 Password Management 3-12.
- Creating a Database Design Template 3-13 Using the DBCA to Delete a Database 3-14 Summary 3-16.
- Practice Overview: Using the DBCA 3-17 4 Managing the Oracle Instance.
- Starting and Stopping Database Control 4-4 Oracle Enterprise Manager 4-5.
- Accessing Oracle Enterprise Manager 4-6 Database Home Page 4-7.
- Starting Up an Oracle Database Instance 4-20.
- Starting Up an Oracle Database Instance: NOMOUNT 4-21 Starting Up an Oracle Database Instance: MOUNT 4-22 Starting Up an Oracle Database Instance: OPEN 4-23 Shutting Down an Oracle Database Instance 4-24 Shutdown Modes 4-25.
- Practice Overview: Managing the Oracle Instance 4-36 5 Managing Database Storage Structures.
- Practice Overview: Managing Database Storage Structures 5-30 6 Administering User Security.
- Practice Overview: Administering Users 6-32 7 Managing Schema Objects.
- Practice Overview: Administering Schema Objects 7-49 8 Managing Data and Concurrency.
- Practice Overview: Managing Data and Concurrency 8-34 9 Managing Undo Data.
- Configuring Undo Retention 9-12 Guaranteeing Undo Retention 9-14 Sizing the Undo Tablespace 9-15 Using the Undo Advisor 9-16 Summary 9-17.
- Practice Overview: Managing Undo Segments 9-18 10 Implementing Oracle Database Security.
- Enterprise Manager Audit Page 10-15 Specifying Audit Options 10-16.
- Practice Overview: Implementing Oracle Database Security 10-30 11 Configuring the Oracle Network Environment.
- Practice Overview: Working with Oracle Network Components 11-32 12 Proactive Maintenance.
- Using the Manage Optimizer Statistics Page 12-7 Statistic Levels 12-9.
- Enterprise Manager and AWR 12-13 Managing the AWR 12-14.
- Enterprise Manager and Advisors 12-20 The DBMS_ADVISOR Package 12-21 Server-Generated Alerts 12-22.
- Practice Overview: Proactive Maintenance 12-32 13 Performance Management.
- SQL Tuning Advisor Options and Recommendations 13-10 Using the SQL Tuning Advisor 13-11.
- Using the SQL Tuning Advisor: Example 13-12 SQL Tuning Advisor: SQL Statistics 13-13.
- SQL Tuning Advisor: Identifying Duplicate SQL 13-14 Using the SQL Access Advisor 13-15.
- Using the Memory Advisor 13-21 Dynamic Performance Statistics 13-22 Troubleshooting and Tuning Views 13-24 Invalid and Unusable Objects 13-25 Summary 13-27.
- Practice Overview: Monitoring and Improving Performance 13-28 14 Backup and Recovery Concepts.
- Phases of Instance Recovery 14-15 Tuning Instance Recovery 14-16 Using the MTTR Advisor 14-17 Media Failure 14-18.
- Practice Overview: Configuring for Recoverability 14-28 15 Performing Database Backups.
- Practice Overview: Creating Database Backups 15-21 16 Performing Database Recovery.
- Practice Overview: Performing Database Recovery 16-13 17 Performing Flashback.
- Flashing Back Dropped Tables Through Enterprise Manager 17-18 Flashback Drop: Considerations 17-19.
- Flashback Versions Query Through Enterprise Manager 17-24 Flashback Versions Query: Considerations 17-25.
- Flashback Transaction Query Through Enterprise Manager 17-27 Flashback Transaction Query: Considerations 17-28.
- Practice Overview: Using Flashback 17-30 18 Moving Data.
- Loading Data with SQL*Loader 18-8 SQL*Loader Control File 18-9 Loading Methods 18-11 Data Pump: Overview 18-13 Data Pump: Benefits 18-14.
- Data Pump Export and Import: Overview 18-15 Data Pump Utility: Interfaces and Modes 18-16 Fine-Grained Object Selection 18-17.
- Data Pump File Locations 18-20 Scheduling and Running a Job 18-22 Data Pump File Naming and Size 18-23 Data Pump Import 18-24.
- Data Pump Import: Transformations 18-25 Data Pump: Performance Consideration 18-27 Performance Initialization Parameters 18-28 Data Pump Access Path: Considerations 18-29.
- Using Enterprise Manager to Monitor Data Pump Jobs 18-30 External Table Population 18-31.
- Practice Overview: Moving Data 18-37 Appendix A: Practices

Xem thử không khả dụng, vui lòng xem tại trang nguồn
hoặc xem Tóm tắt