Course Details

Previous Page


Connectivity and Space Management in Oracle Database 12c


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



Overview/Description
Key aspects of administering Oracle Database 12c include managing client connections to database servers and optimizing the ways data is stored to conserve space and improve system performance. In this course, you'll learn how to manage Oracle Net Services. You'll also learn how to work with tablespaces and data files, and how to manage the space used by the core storage structures, data blocks and segments. Finally, you'll learn about the Undo feature 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).

Target Audience
Data warehouse administrator; database administrators; database designers; support engineer; technical administrator

Prerequisites
None

Expected Duration (hours)
2.6

Lesson Objectives

Connectivity and Space Management in Oracle Database 12c

  • start the course
  • describe the functions of Oracle Net Services and Oracle Net Listener with Oracle Database 12c
  • use Oracle Net Services to connect to an Oracle Database 12c database instance
  • configure naming methods for connecting to an Oracle Database 12c database
  • describe and use tools for managing Oracle Net Services to manage connectivity with Oracle Database 12c
  • use the Oracle Net Configuration Assistant and the Listener Control utility to configure Oracle Database 12c
  • configure advanced connection options and test Oracle Net connectivity with Oracle Database 12c
  • describe dedicated and shared server configurations in Oracle Database 12c
  • configure communication between Oracle Database 12c database instances
  • describe how table data is stored in Oracle Database 12c
  • create a new tablespace in Oracle Database 12c
  • describe the default tablespaces created in a database and the options for altering the status or state of a tablespace
  • add a data file to a tablespace, modify a data file, and rename and move data files in Oracle Database 12c
  • describe and use Oracle Managed Files (OMF) in Oracle Database 12c
  • monitor Tablespace disk usage in Oracle Database 12c
  • describe block space management, including the use of row chaining and migration, in Oracle Database 12c
  • describe segment types and the allocation of segments to extents, and manage free space within segments in Oracle Database 12c
  • describe and control deferred segment creation in Oracle Database 12c
  • describe the phases of a table shrink operation
  • use the Automatic Segment Advisor to shrink segments online in Oracle Database 12c
  • shrink Oracle Database 12c segments using SQL and Enterprise Manager
  • manage resumable space allocation in Oracle Database 12c
  • describe the types and uses of table compression in Oracle Database 12c
  • use the Compression Advisor and the DBMS_COMPRESSION package to compress tables in Oracle Database 12c
  • describe the use of undo records in Oracle Database 12c
  • manage undo records and configure undo retention in Oracle Database 12c
  • describe and enable the Temporary Undo feature in Oracle Database 12c
  • monitor undo operations and use the Undo Advisor in Oracle Database 12c
  • create a tablespace, add a data file, and manage Undo operations in Oracle Database 12c
  • Course Number:
    od_dbre_a02_it_enus