oracle10g 数据库介绍课件.ppt

;;Database Management Challenges;Oracle Database 10g Solution: Self-Managing Database;How DBAs Spend Their Time;How Oracle Database 10g DBAs Spend Their Time;IT 架构;易于使用, 易于管理;;;;;;Oracle Database 10g;Embedded Database;Oracle Database 10g Editions;快速, 轻量的安装;易于使用, 易于管理;自动诊断的智能数据库ADDM;;;Oracle 10g Standard Edition;Oracle 10g 数据库打包情况;Oracle 10g 数据库打包情况;Oracle 10g 数据库打包情况;Oracle 10g 数据库打包情况;;概述;Oracle 实例;进程结构;SMON: 系统监测;PMON: 进程监测;归档;;介绍几个主要实用的新特性;Data Pump Export and Import: Benefits;Parallel Full Export and Import: Example;Limited Schema Export: Example;Attaching to Existing Job: Example;Data Pump and Filtering;Data Pump Import Transformations;Data Pump Job Monitoring Views;介绍几个主要实用的新特性;External Table Population: Overview;External Table Population Operation;External Table Parallel Populate Operation;External Table Population: Example;介绍几个主要实用的新特性;Automatic Shared Memory Management: Overview;Benefits of Automatic Shared Memory Management;Manual Configuration;Using the V$PARAMETER View;介绍几个主要实用的新特性;Automatic Undo Retention Tuning;介绍几个主要实用的新特性;Scheduling Needs;Scheduler Concepts;Privileges for Scheduler Components;Creating a Scheduler Job;Creating a Scheduler Job: Example;Using Scheduler Programs;Specifying Schedules for a Job;Creating and Using Schedules;Creating a Job Class;Viewing Job Execution Details;Purging Job Logs;Data Dictionary Views;介绍几个主要实用的新特性;What Is Automatic Storage Management?;;ASM Instance Functionalities;ASM Instance Creation;ASM Instance Initialization Parameters;Accessing an ASM Instance;Dynamic Performance View Additions;Starting Up an ASM Instance;;ASM Disk Group;Disk Group Dynamic Rebalancing;Monitoring Long-Running Operations Using V$ASM_OPERATION;;ASM Files;ASM File Names;ASM File Name Syntax;介绍几个主要实用的新特性;;SYSAUX Tablespace: Benefits;SYSAUX Occupants;CREATE DATABASE;SYSAUX Tablespace: General Usage;SYSAUX Occupants: Relocation Using SQL;Tablespace Rename: Considerations;Default Permanent Tablespace: Overview;ALTER DATABASE DEFAULT