Connectivity & Space Management

Oracle 12c    |    Intermediate
  • 15 videos | 1h 17m 35s
  • Includes Assessment
  • Earns a Badge
Rating 4.2 of 5 users Rating 4.2 of 5 users (5)
Optimizing how data is stored in Oracle Database 12c conserves space and improves system performance. Explore tablespaces and data files, and learn how to manage the space used by data blocks and segments.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Locked
    1.  Table Data Storage
    3m 52s
    After completing this video, you will be able to describe how table data is stored in an Oracle Database 12c. FREE ACCESS
  • Locked
    2.  Creating Tablespaces
    7m 9s
    In this video, you will learn how to create a new tablespace in Oracle Database 12c. FREE ACCESS
  • Locked
    3.  Modifying Tablespaces
    6m 51s
    Upon completion of this video, you will be able to describe the default tablespaces created in a database and the options for altering the status or state of a tablespace. FREE ACCESS
  • Locked
    4.  Adding and Modifying Data Files
    5m 26s
    Learn how to add a data file to a tablespace, modify a data file, and rename and move data files in Oracle Database 12c. FREE ACCESS
  • Locked
    5.  Using Oracle Managed Files
    5m 27s
    Upon completion of this video, you will be able to describe and use Oracle Managed Files in Oracle Database 12c. FREE ACCESS
  • Locked
    6.  Monitoring Tablespace Disk Usage
    4m 52s
    To find out how to monitor Tablespace disk usage in Oracle Database 12c, consult the Oracle documentation. FREE ACCESS
  • Locked
    7.  Managing Data Block Space
    5m 32s
    Upon completion of this video, you will be able to describe block space management, including the use of row chaining and migration, in Oracle Database 12c. FREE ACCESS
  • Locked
    8.  Managing Segments
    4m 58s
    Upon completion of this video, you will be able to describe segment types and how segments are allocated to extents, and manage free space within segments in Oracle Database 12c. FREE ACCESS
  • Locked
    9.  Deferred Segment Creation
    5m 6s
    Upon completion of this video, you will be able to describe and control deferred segment creation in Oracle Database 12c. FREE ACCESS
  • Locked
    10.  Shrinking Segments
    3m 59s
    Upon completion of this video, you will be able to describe the phases of a table shrink operation. FREE ACCESS
  • Locked
    11.  Using the Automatic Segment Advisor
    4m 39s
    Learn how to shrink segments online in Oracle Database 12c using the Automatic Segment Advisor. FREE ACCESS
  • Locked
    12.  Manually Shrinking Segments
    4m 6s
    In this video, you will learn how to shrink Oracle Database 12c segments using SQL and Enterprise Manager. FREE ACCESS
  • Locked
    13.  Managing Resumable Space Allocation
    5m 43s
    In this video, you will learn how to manage resumable space allocation in Oracle Database 12c. FREE ACCESS
  • Locked
    14.  Table Compression Overview
    6m
    Upon completion of this video, you will be able to describe the types and uses of table compression in Oracle Database 12c. FREE ACCESS
  • Locked
    15.  Compressing Tables
    3m 56s
    In this video, you will learn how to use the Compression Advisor and the DBMS_COMPRESSION package to compress tables in Oracle Database 12c. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Final Exam: Working with Azure Cosmos Database
Rating 4.3 of 3 users Rating 4.3 of 3 users (3)
Book Pro Oracle SQL Development: Best Practices for Writing Advanced Queries, Second Edition
Book DBA Essentials for 21c: Installing Oracle Database 21c on OCI Compute

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Backing Up & Recovering Data
Rating 4.6 of 25 users Rating 4.6 of 25 users (25)
Course Grid Infrastructure
Rating 4.4 of 34 users Rating 4.4 of 34 users (34)
Book The Linux Command Line: A Complete Introduction, 2nd Edition