Global Vendors Training

Home > > 전체교육일정


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

Oracle전체일정보기 수강신청


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

본 과정은 세가지 모듈로 구성됩니다. SQL 신기능 및 도구 사용, DB 아키텍처 이해 및 데이터베이스 문제 진단과 관련하여 학습하게 됩니다.
수강생들은 주로 On-Premise Multitenant 데이터베이스의 다양한 데이터베이스 관리 영역에서 Oracle Database 12c Release 2의 새롭고 향상된 기능에 대해
잘 알 수 있습니다.


- Create and manage pluggable databases
- Describe the challenges and benefits of a sharded database
- Handle the ADR automatic file space
- Diagnose database issues by using the Trace File Analyzer collector
- Use the new SQL*Plus history commands and SQL enhancements such as long identifiers
- Use the SQLcl new utility as the new SQL command line interface
- Create and manage a multitenant container database


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 Basicsl 
- Challenges
- Configurations
- 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
- Tools
- 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
- 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. Back 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


교육비는 부가세 포함