회사이미지

Global Vendors Training

Home > Global Vendors Training > 전체교육일정

전체교육일정

Oracle Database 12c: New Features for Administrators(DBA에 꼭 필요한 오라클 12c 새로운 기능)

교육일정
교육기간
5일
교육금액
1,985,500원(부가세포함)
전체일정보기 수강신청

교육개요

* 09:30 ~ 16:30 (30시간 / 5일)
* 이 과정은 오라클 공인교육으로 글로벌널리지가 아닌 오라클 공인교육센터에서 운영됩니다.
(공인교육센터 위치 : 서울시 강남구 학동로 171 2층 영우글로벌러닝)

본 과정은 Oracle Database 12c의 Cloud DB라는 컨셉에서 만들어진 Container Database의
개념에 대해 학습하는 과정입니다.

컨테이너 하나의 DB를 물리적으로 분리된 복수 개의 서브 DB인 Pluggable DB로 구성할 수
있도록 기존의 멀티 인스턴스 환경에서 리소스의 낭비를 줄이고, 빠르고 쉽게 DB 환경을
프로비져닝할 수 있는 기능에 대해 학습합니다.

더불어 Security, Online 기능, 자동 ILM 관리 기능을 비롯하여, 12c의 혁신적 기능에 대해서
알아보는 과정입니다.



교육목표

- 리소스 매니저를 통하여 멀티테넌트 컨테이너 데이터 베이스와 pluggable 데이터베이스를 생성, 관리, 모니터링 할 수 있다.
- 데이터파일 온라인 운영 관리, heat map과 자동 데이터 최적화를 실시할 수 있다.
- SYSBACKUP과 같은 권한이나 감사와 관련된 새로운 기능을 사용하여 보안 관리를 할 수 있다.
- Recovery 매니저의 개선 기능을 사용할 수 있다.
- Real-Time ADDM과 Period ADDM, DB 모니터링 등으로 성능 관리를 할 수 있다.
- 새로운 in-memory 기능을 이해하고, Full Database In-Memory Caching과 Automatic Big Table Caching을 알 수 있다.
- 오라클 데이터 펌프의 새로운 기능과 SQL*Loader Express 모드를 활용할 수 있다.
- 확장 데이터 타입 컬럼과 SQL row limiting 구문과 같은 SQL 개선과 관련된 새로운 기능을 활용할 수 있다.



수강대상

- 데이터베이스 관리자/개발자
- Technical Architect, System Administrator
- 기술 지원 전문가



선수과목

없음



강의내용

1. Enterprise Manager and Other Tools
- Enterprise Manager (EM) Cloud Control home page
- Enterprise Manager Express home page versus Enterprise Manager Database Control
- SQL Developer with new functionalities
- OUI, DBCA
2. Basics of Multitenant Container Database (CDB)
- Benefits of the multitenant architecture
- Differences between the root container and pluggable database containers
- Structure of the root
- Structure of Pluggable Database (PDB)
- CDB_xxx and DBA_xxx views
- Impacts in Security, Data Guard, Oracle GoldenGate, Oracle Streams, XStream, and Scheduler
3. Configuring and Creating CDB and PDBs
- Tools: DBCA and SQL*Plus
- Configuration and creation of CDB
- Exploring the Structure (CDB_xxx views and EM)
- Tools used: SQL Developer, DBCA and SQL*Plus and EM Database Express
- Create a new PDB from PDB$SEED
- Create a PDB from a non-CDB
- Clone a PDB into the same CDB or into another CDB using DB links
- Plug in an unplugged PDB
4. Managing CDB and PDBs
- Connect to CDB as administrator
- Connect to a PDB using a service name
- Start up a CDB
- Open / Close a PDB (SQL*Plus, srvctl, EM)
- Open / Close all PDBs
- Shut down a CDB
- Preserve or discard the PDBs open mode when the CDB restarts
- Change PDB state
5. Managing Tablespaces, Common and Local Users, Privileges and Roles
- Create permanent tablespaces in the root and PDBs
- Manage common and local schemas and users in the root and PDBs
- Manage system and object privileges to common and local grantees granted ""commonly"" or ""locally""
- Manage common and local roles granted ""commonly"" or ""locally""
6. Managing Backup / Recovery / Flashback
- Backup a whole CDB
- Backup a PDB
- Recover CDB from redo log files, control files, undo datafiles loss
- Recover PDB from PDB datafiles loss
- Flashback at CDB level
- Explain the two methods of migration
7. Online Datafile Move and Automatic Data Optimization
- Data classification in 12c : tablespace, group, object, row levels
- Configure heat map
- Automatic movement and compression
- Compression levels and types
- Policy declaration: simple declarative SQL extension
- Customized automated action execution with user-defined function
- Execution in scheduled maintenance windows and by MMON
- Customized schedule with DBMS_ILM package
8. In-Database Archiving
- Challenges of old data in tables and 11g solutions
- In-database archiving new solutions
- Use ROW ARCHIVAL clause to enable row lifecycle state for applications
- Set ROW ARCHIVAL VISIBILITY for session level visibility control
- Use predicate on ORA_ARCHIVE_STATE column
- Temporal Validity versus Temporal History (Transaction Time of FDA)
- New clause of CREATE / ALTER TABLE to set a Temporal Validity: PERIOD FOR
- New SQL temporal data type
9. Auditing Enhancements
- Review of 11g R2 audit trail implementation
- Overview of the Unified Audit Trail
- Enabling the Unified Audit Trail
- Creating a separate tablespace for the unified audit trail
- Granting the AUDIT_ADMIN role to a user for audit trail configuration and management
- Configuring the Unified Audit Trail to set a tolerance level for loss of audit records
- Creating audit policies
10. Privileges Enhancements
- Implementing Separation of Duty for Database Administration Tasks
- Using Database Privilege Analysis
- Overview of Database Privilege Analysis
- Granting the CAPTURE_ADMIN role to enable management of privilege captures
- Creating and starting/stopping privilege captures
- Viewing privilege profile data
- Querying DBA_PRIV_CAPTURES
- Explaining the purpose of the default ORA$DEPENDENCY profile
11. Oracle Data Redaction
- Overview of Oracle Data Redaction
- Types of Masking Policies
- Administering the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
- Managing Masking Policies
- Best practices for defining policy expressions
- Understanding Masking of Statements Containing Subqueries
- Viewing Information About Masking Policies by Querying REDACTION_POLICIES and REDACTION_COLUMNS
12. General RMAN New Features and FDA Enhancements
- Making Database Connections With RMAN
- Using the SYSBACKUP Privilege
- Using SQL, DESCRIBE Command, Duplication Operation with the NOOPEN option
- Backing up and Restoring Very Large Files
- Creating Multisection Backups
- Transporting Data Across Platforms
- Prerequisites and Limitations
- Transporting Data: Processing steps
13. Monitoring DB Operations
- Overview
- Use cases
- Current Tools
- Define a DB operation
- Monitoring: Bracketing an Operation
- Monitoring the Progress of Operations
- DB Operation Tuning
- DB Operation Active Report
14. Real-Time ADDM and Compare Period Advisor
- Emergency Monitoring
- Real time ADDM
- Use cases
- Goals
- Define Workload dimensions
- Reported items
- Root Causes
- Requirements for a report
15. ADR and Network Enhancements
- ADR file types
- New File types
- New File locations
- New command for ADRCI
- Improve performance by Compression
- Setup Compression
16. In-Memory Column Store
- In-Memory Database option goals and benefits
- Row format and columnar format
- New SGA component:
- IMCU synchronization
- Deployment and behaviors
- Compression ratio
- New dictionary tables and added columns
- New statistics: IM %
17. In-Memory Caching
- Setting up Full Database In-Memory Caching
- Using Full Database In-Memory Caching
- Explaining the two buffer replacement algorithms of Automatic Big Table Caching
- Configuring Automatic Big Table Caching with PARALLEL_DEGREE_POLICY and DB_BIG_TABLE_CACHE_PERCENT_TARGET initialization parameters
- Using Automatic Big Table Caching
18. SQL Tuning
- Adaptive Execution Plans
- SQL Plan Directives
- Statistics Gathering Performance Improvements
- Histogram Enhancements
- Enhancements to Extended Statistics
- Adaptive SQL Plan Management
19. Resource Manager and Other Performance Enhancements
- Manage resources between PDBs
- Manage resources within a PDB
- Manage resources with CDB and PDBs plans
- Manage runaway queries
- Control the in-memory database repopulation resource consumption
- Automated maintenance tasks
- Current Architecture: Unix multiprocess / one thread, NT/Windows one process / multithread
- New Architecture: Multiprocess / MultiThread
20. Index and Table Enhancements
- Multiple indexes on the same set of columns as long as some characteristic is different
- Create table with INVISIBLE columns
- Support for invisible columns
- Describe online redefinition supports
- Explain LOCK timeout during FINISH_REDEF_TABLE
- Describe the Advanced Row Compression
- Using the following DDL statements in an online manner
21. Oracle Database Cloud Service: Overview
- Database as a Service Architecture & Features and Tooling
- Software Editions: Included Database Options and Management Packs
- Automated Database Provisioning
- Managing the Compute Node Associated With a Database Deployment
- Backing Up and Recovering Databases on Database as a Service
- Performing Recovery by Using the Service Console
- Patching Database as a Service
- Using the Oracle Database Cloud Service Console to Manage Patches



기타

교육비 부가세포함