Managing an Oracle Database 12c Instance

Data warehouse administrators; database administrators; database designers; support engineers; technical administrators

Prerequisite
None

Expected Duration
153 minutes

Description
An understanding of the memory, process, and storage architecture – along with the new multitenant architecture – in Oracle Database 12c is a good foundation for working with Oracle database instances. In this course, you’ll learn about all the key architectural structures in Oracle Database 12c and how they work together. You’ll learn about the main tools for managing Oracle database instances. You’ll then learn how to get started, configuring initialization parameters, starting up a database instance, working with log files, and using the various database views in Oracle Database 12c. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c Installation and Administration exam (1Z0-062).

Objective

Multitenant and Memory Architecture

  • start the course
  • describe the new multitenant architecture and support for cloud computing in Oracle Database 12c
  • describe the database server architecture and key memory structures in Oracle Database 12c
  • identify the functions of the shared pool
  • identify the functions of the buffer cache and the redo log buffer in Oracle Database 12c
  • explain the functions of the large, Java, and Streams pools and the role of the Program Global Area in Oracle Database 12c
  • describe the new In-Memory column store, as well as in-memory caching of row data, in Oracle Database 12c

Process Architecture

  • provide an overview of the process architecture and process structures in Oracle Database 12c
  • describe the database writer and log writer processes in Oracle Database 12c
  • describe the checkpoint, system monitor, and process monitor processes in Oracle Database 12c
  • describe the recoverer, listener registration, and archiver processes in Oracle Database 12c

Data Storage Architecture

  • provide an overview of the database storage architecture used in Oracle Database 12c
  • describe the logical and physical storage structures used in Oracle Database 12c
  • explain the new multitenant container database in Oracle Database 12c
  • describe key features of Automatic Storage Management in Oracle Database 12c

Oracle Database Management Tools

  • describe the Oracle Database 12c database management tools, SQL*Plus and SQL Developer
  • access Enterprise Manager (EM) Database Express and provide an overview of the options it provides for managing Oracle Database 12c
  • start Oracle Enterprise Manager Cloud Control and describe its core components in Oracle Database 12c
  • use Enterprise Manager Cloud Control in Oracle Database 12c

Initialization, Startup, and Shutting Down

  • identify types of initialization parameters and the files that contain them in Oracle Database 12c
  • configure key initialization parameters in Oracle Database 12c
  • describe how to use SQL*Plus to view and configure initialization parameters for Oracle Database 12c
  • explain the steps that occur when you start up a database instance in Oracle Database 12c
  • explain what occurs when you shut down a database instance, as well as the available shutdown modes, in Oracle Database 12c

Logging

  • view the alert log and find and use trace files in Oracle Database 12c
  • administer the DDL log file and use the debug log file in Oracle Database 12c

Database Views

  • describe and use dynamic performance views in Oracle Database 12c
  • describe and use the data dictionary views in Oracle Database 12c

Practice: Getting Started

  • configure initialization parameters, start a database instance, and use different views in Oracle Database 12c

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.