Global Vendors Training

Home > > 전체교육일정


Oracle Database 12c R2: New Features for Administrators Part 2

Oracle전체일정보기 수강신청


* 09:30 ~ 17:00 (30시간 / 5일) (점심시간이 1시간 30분)

본 과정은 데이터 보안 모듈, 데이터 사용 가능 모듈, 파티셔닝 데이터 모듈, 정보 수명주기 관리 모듈 및 모니터링 DB 운영 및 성능 관리 모듈로 구성됩니다.
(TDE) 및 기타 보안 영역, Recovery Manager, 온라인 운영, Oracle Data Pump, SQL Loader, 새로운 분할 방법, 자동 데이터 최적화, 메모리 내부 열 저장소,
전체 데이터베이스 입력과 같은 데이터베이스 관리 - 메모리 캐싱 및 자동 빅 테이블 캐싱에 대해 학습합니다.


- Manage security by using Unified Auditing
- Manage security by using privileges and profiles
- Manage security by using Privilege Analysis
- Manage security by using Data Redaction
- Manage security by using Transparent Data Encryption
- Manage security by using Transparent Sensitive Data Encryption
- Describe the new RMAN enhancements
- Manage data availability by using new features of Oracle Data Pump, SQL*Loader and external tables
- Manage data availability by performing online operations
- Manage data partitioning
- Manage Information Lifecycle by using ADO
- Manage Information Lifecycle by using In-Database Archiving and Temporal features
- Describe database operations
- Configure and use In-Memory Column Store
- Use In-Memory Caching
- Use Real Application Testing enhancements


End Users / Database Administrators / System Administrator




1. Introduction
Understanding DB architectures
Diagnosing database problems
Global objectives of the course
Schedule of the week
Using SQL new features and tools
Lessons grouped by modules

2. Using SQL New Features and SQLcl
Use SQL row-limiting clause
Use new 128 bytes identifier length for database objects
Describe the support for invisible and hidden columns
Increase length limits of data types
Use the new VALIDATE_CONVERSION function
Recall SQL*Plus commands in the same session from history
Describe the new SQLcl utility

3. Understanding CDB Basics
CDB root and pluggable database containers
SYSTEM objects in the USER container
New Multitenant Architecture: Benefits
Non-CDB Architecture vs Oracle Multitenant Container Database
A pristine installation
Provisioning a pluggable database

4. Creating CDB and Regular PDBs
Create a CDB using new clauses
What's new in CDB after CDB creation
Data dictionary views
Provisioning new PDBs: overview
What to do in CDB after CDB creation

5. Creating Application PDBs and Installing Applications
PDBs and applications
Application common objects
Create and manage an application container
Types of containers
Patch and upgrade applications
Regular PDBs vs application PDBs
Application containers
Install applications

6. Creating PDBs
Cloning regular and application containers PDBs
Converting regular PDBs to application root or PDBs
Cross-Platform transportable PDB
Plugging unplugged regular and application PDBs into CDB
Plugging unplugged PDBs with encrypted data
Perform hot cloning and relocation
Configure and use locla UNDO mode
Plugging or cloning a non-CDB into a CDB

7. Managing CDB and PDBs
Creating and renaming Services
Switching Connection
Opening CDBs and PDBs
Managing CDB and PDBs
Mounting a CDB
Evaluating the impact of parameter value changes
Changing the different modes and settings of PDBs
Starting Up a CDB Instance

8. Managing Storage
Creating Permanent Tablespaces in a CDB
Objects in Tablespaces
UNDO Tablespaces
Tablespaces Created During PDB Creation
Temporary Tablespaces
Defining Default Permanent Tablespaces

9. Managing Security
Enabling Common Users to Access Data in PDBs
Encrypting data in PDBs
Creating common users, roles and profiles in CDB and PDBs
Protecting data with Database Vault policies in CDB and PDBs
Common objects in Application PDBs and operations on Data-Linked objects
Granting privileges commonly in CDB and PDBs
Auditing users in CDB and PDBs
Managing PDB lockdown profiles

10. Backing up, Recoverying and Flashing Back
Instance failure and instance recovery
CDB and PDB backups
PDB point-in-time recovery
New syntax and clauses in RMAN
PDB tempfile, essential and non-SYSTEM tablespaces recovery
CDB and PDB flashback
Duplicating PDBs
Using RMAN backup to plug an unplugged PDB

11. Managing Performance
Monitoring PDB memory usage
AWR report
Managing SGA and PGA for PDBs
Controlling the Degree of Parallelism of Queries
PDB-Level snapshot views
AWR and ADDM behaviour at CDB and PDB levels
Sizing the CDB
Tuning a CDB

12. Managing Resources Allocation
Controlling PDB IO rate limit
Managing resources within a PDB
CDB Resource plan basics: Limits + cpu_count init parm per PDB
Creating and setting PDB performance profiles
Allocating resources in the CDB and PDBs
Managing resources between PDBs

13. Moving and Migrating Data
Transporting a database over the network
Exporting non-CDB data and importing non-CDB data into PDB
Using SQL*Loader with PDBs
Exporting and importing between PDBs
Exporting from PDB and importing into a non-CDB
Full Transportable export/import
Using Oracle Data Pump with PDBs

14. Performing Miscellaneous Operations
Using utility to install/remove options from CDB/PDB
Jobs coordinator and resources
Creating a standby of a CDB
Using Xstreams with a CDB and PDB
Mining statements of a PDB using LogMiner
Scheduling operations in a PDB

15. Understanding Database Sharding
Benefits of Sharding
Advantages of Oracle Sharding over NoSQL
Creating Sharded Tables
Sharded Table Family
What Is Database Sharding?
Application Considerations for Sharding
Components of Database Sharding
Complete Deployment of a System-Managed SDB

16. Diagnosing Database Problems
TFA Collector utility
Tracing Data Pump
New ADRCI Command
Automatic Diagnostic Repository
MVs refreshed statistics history
Trace File Analyzer (TFA) Collector process and repository
ADR Retention
Network Performance


교육비는 부가세 포함