회사이미지

Global Vendors Training

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

전체교육일정

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

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

교육개요

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

오라클 Database12c:관리자의 새로운 기능에 대한 새로운 기능은 오라클 Database12c의 새로운 기능과 향상된 기능 및 옵션에 대해 소개하며,
전문 강사들은 이러한 특징과 옵션이 보안, 관리 용이성 및 성능을 향상시키는 방법을 학습니다.
이 과정에서는 Oracle데이터베이스 클라우드 서비스에 대해 소개합니다.



교육목표

- Explore new Oracle Data Pump features and SQL*Loader Express Mode
- Create, manage and monitor multitenant container databases and pluggable databases and their resources consumption with Resource Manager
- Manage datafile online operations, heat map and automatic data optimization, archive data using Row-archival or Temporal Validity and
Temporal History
- Manage security by using the new unified auditing, the new privileges, such as SYSBACKUP, the privilege analysis, and by creating and
managing Data Redaction policies
- Use the Recovery Manager enhancements
- Manage the database performance with monitoring DB operations, Real-Time ADDM and Compare Period ADDM
- Understand the new in-memory capabilities of the Database In-Memory, Full Database In-Memory Caching, and Automatic Big Table Caching
- Tune the SQL performance using Adaptive Execution Plans, SQL Plan Directives and statistics enhancements
- Use online operations during partition movement and compression, and other DDL operations
- Use partial global partitioned indexes
- Explain new SQL enhancements such as extended data type column and SQL row limiting clause
- Gain an understanding of the Oracle Database Cloud Service



수강대상

Administrator / Database Administrators / System Administrator
Related Training / Required Prerequisites /
Good knowledge of Oracle Database 11g



선수과목

없음



강의내용

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



기타

교육비 부가세포함