Connectivity & Space Management

Oracle 12c
  • 15 Videos | 1h 24m 5s
  • Includes Assessment
  • Earns a Badge
Likes 4 Likes 4
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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

CHANNEL Oracle RAC
Likes 27 Likes 27