Základní info
Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 1 course constituted by three modules; the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration, mainly in on-premises Multitenant databases.bLearn To:/pse the new SQLcl utility and gain information on SQL*Plus and SQL enhancements.nderstand the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as the new Multitenant architecture and the Sharded database architecture.iagnose database issues, handling Automatic Diagnostic Repository (ADR) file management and using the Trace File Analyzer (TFA) tool.b Benefits To You/pou will benefit from learning the following lessons:sing the QL New Features and Toolsmodule covers the usage of the new SQLcl utility and the new features in SQL*Plus and SQL.ost of the nderstanding DB Architecturesmodule lessons cover the new Multitenant architecture. The concept of regular and application containers of a Multitenant container database includes new administrative tasks such as creating, managing, securing, backing up, recovering and upgrading regular and application containers, as well as migrating an 11g database to a 12c multitenant container database. The lessons also cover enhanced features of Resource Manager to help you manage the resources within a Multitenant container database. You will discover other enhancements supported in a Multitenant container database like heat map and Automatic Data Optimization (ADO) support, Database Vault and encryption. The second part of the module gives an overview of database sharding. It describes the challenges and benefits of a sharded database, the sharded database architecture and how to configure a sharded database.he lesson of the iagnosing Database Problems module covers enhancements in ADR space management and explain what can be completed with the Trace File Analyzer (TFA) tool in terms of database diagnosis./ul
