Oracle Database 12c R2: New Features for 12c R1 Administrators (12c R1-> R2 새로운 기능)

기술분야 ORACLE 신청하기
교육일정 2018-06-18~2018-06-22 교육 기간 5 일
교육 금액 1,985,500원 쿠폰등록시 0매
접수파일
이벤트&프로모션
교육비는 부가세 포함 가격입니다.
과정 설명
* 09:30 ~ 16:30 (30시간 / 5일)
* 이 과정은 오라클 공인교육으로 오라클 공인교육센터에서 운영됩니다.
(공인교육센터 위치 : 서울시 강남구 학동로 171 2층 영우글로벌러닝)

오라클 Database12c:관리자의 새로운 기능에 대한 새로운 기능은 오라클 Database12c의 새로운 기능과 향상된 기능 및 옵션에 대해 소개하며,
전문 강사들은 이러한 특징과 옵션이 보안, 관리 용이성 및 성능을 향상시키는 방법을 학습니다.
이 과정에서는 Oracle데이터베이스 클라우드 서비스에 대해 소개합니다.
수강 대상
- 데이터베이스 관리자
- 데이터베이스 개발자
과정 소개
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
선수과정
없음
교육 장소
한국글로벌널리지 교육센터

[찾아오시는 길]
서울특별시 강남구 테헤란로 222 도원빌딩 3층~4층

[교육장 약도]