上海涛德顾问学院

11g OCM升级课程大纲

Oracle 10g OCM 升级 11g 培训

 

课程时间5

 

课程特色

Oracle大学首席讲师、OCM考官全程主讲

100%保证中国最佳10g 升级11g实验模拟考试环境

课程完全基于ORACLE 11g OCM 升级考试内容

以实验巩固培训内容

以模拟考验证学习效果

当前涛德OCM升级一次通过率:95%以上 

课程内容:

Database, RMAN, EM and Network Configuration

Configure server-side network

Configure client-side network

Create and Manage encrypted tablespaces

Create and Manage a tablespace that uses NFS mounted file system file

Set up ADR file based repository

Perform cold database backup

Manage user accounts and use case sensitive passwords

Use OPatch to install a patch

Install and configure EM Agent

Create Base Recovery Catalog

Configure RMAN

Perform multisection backup of a datafile

Create an Archival Backup


Data Guard

Create Physical Standby Database with real-time apply.

Configure the data guard environment to reduce overheads of fast incremental backups on the primary database

Configure the Observer

Switchover and switch back

Convert the standby to a snapshot standby

Configure archivelog deletion policy for the dataguard configuration


Data and Data Warehouse Management

Troubleshoot fast materialized views to fast refresh and query rewrite

Add a tablespace by using Transportable Tablespace Feature of Data Pump Import (cross platform transportable tablespace)

Configure a schema to support a star transformation query

Configure and use parallel execution for queries

Use and access SecureFile LOBS

Create partitioned tables (includes reference and interval partitioning)

Configure Flashback Data Archive

Use Oracle Streams to capture and propagate changes in a table


Performance Management

Set up and configure Resource Manager to control active sessions, number of I/Os, execution time

Use Result Cache

Use multi column statistics

Gather statistics on a specific table without invalidating cursors

Use partitioned indexes

Use SQL Tuning Advisor

Use SQL Access Advisor

Configure baseline templates

Use SQL Plan Management feature

Replay a captured workload

    涛德人工智能培训5月最低年薪45万
    联系

    上海涛德顾问学院 ( 沪ICP备14006824号 )  

    GMT+8, 2018-9-18 22:39 , Processed in 0.137001 second(s), 11 queries , Gzip On.

    Top Data World

    回顶部