Oracle Database 12c – Administration: Storage structures and Undo Data


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
An Oracle database is divided into logical storage units called tablespaces. Oracle also provides Oracle-Managed Files (OMF), which eliminate the need for the DBA to directly manage the operating system files in the Oracle database. Managing undo data is also important DBA role. Data is manipulated using DML, and undo data exists as a copy of the original, premodified data and is captured for every transaction that changes data. This course describes the purpose and functions of tablespaces, including how to manage segments and resumable space allocation. This course also describes how to manage undo data. This course is one of a series in two SkillSoft learning paths that covers the objectives for the 1Z0-062Oracle Database 12c: Installation and Administration. This exam is part of the Oracle Database 12c Administrator Certified Associate, OCA, certification path.

Target Audience
Database Administrators, support engineers, technical administrators, and Data Warehouse Administrator who wish to learn how to install Oracle Database 12c and upgrade from previous versions.

Prerequisites
None

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 12c – Administration: Storage structures and Undo Data

  • recognize the configuration options available when creating Oracle Database 12c tablespaces
  • describe how to manage Oracle Database 12c tablespaces
  • recognize how to space is managed in Oracle Database 12c using segments
  • describe how to monitor space allocation in Oracle Database 12c
  • manage threshold levels on a database tablespace
  • describe the characteristics of the undo data feature
  • manage tablespaces and undo data in a database
  • Course Number:
    od_oadm_a04_it_enus