Oracle Database Instance Overview

Oracle 12c    |    Intermediate
  • 14 videos | 1h 7m 19s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 97 users Rating 4.5 of 97 users (97)
To work with Oracle database instances, you must understand the new multitenant architecture in Oracle Database 12c. Explore the memory, process, and storage architectures and how they work together.

WHAT YOU WILL LEARN

  • 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
    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
    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

IN THIS COURSE

  • Locked
    1.  Multitenant Architecture and Cloud Computing
    4m 18s
    After completing this video, you will be able to describe the new multitenant architecture and support for cloud computing in Oracle Database 12c. FREE ACCESS
  • Locked
    2.  Database Server Architecture and Memory Structures
    6m 25s
    Upon completion of this video, you will be able to describe the database server architecture and key memory structures in Oracle Database 12c. FREE ACCESS
  • Locked
    3.  The Shared Pool
    3m 50s
    In this video, find out how to identify the functions of the shared pool. FREE ACCESS
  • Locked
    4.  The Buffer Cache and Redo Log Buffer
    3m 13s
    In this video, you will learn how to identify the functions of the buffer cache and the redo log buffer in Oracle Database 12c. FREE ACCESS
  • Locked
    5.  Large, Java, and Streams Pools and the PGA
    4m 15s
    After completing this video, you will be able to explain the functions of the large, Java, and streams pools and the role of the Program Global Area in Oracle Database 12c. FREE ACCESS
  • Locked
    6.  In-Memory Data Storage
    7m 39s
    After completing this video, you will be able to describe the new in-memory column store, as well as in-memory caching of row data, in Oracle Database 12c. FREE ACCESS
  • Locked
    7.  Process Architecture Overview and Structures
    5m 7s
    After completing this video, you will be able to provide an overview of the process architecture and process structures in Oracle Database 12c. FREE ACCESS
  • Locked
    8.  The DBW and LGWR Processes
    7m 49s
    After completing this video, you will be able to describe the database writer and log writer processes in Oracle Database 12c. FREE ACCESS
  • Locked
    9.  The CKPT, SMON, and PMON Processes
    3m 1s
    Upon completion of this video, you will be able to describe the checkpoint, system monitor, and process monitor processes in Oracle Database 12c. FREE ACCESS
  • Locked
    10.  The RECO, LREG, and ARCn Processes
    3m 37s
    Upon completion of this video, you will be able to describe the recoverer, listener registration, and archiver processes in Oracle Database 12c. FREE ACCESS
  • Locked
    11.  Overview of Database Storage Architecture
    6m 35s
    After completing this video, you will be able to provide an overview of the database storage architecture used in Oracle Database 12c. FREE ACCESS
  • Locked
    12.  Logical and Physical Storage Structures
    4m 37s
    Upon completion of this video, you will be able to describe the logical and physical storage structures used in Oracle Database 12c. FREE ACCESS
  • Locked
    13.  The Multitenant Container Database
    3m 6s
    After completing this video, you will be able to explain the new multitenant container database in Oracle Database 12c. FREE ACCESS
  • Locked
    14.  Automatic Storage Management
    3m 49s
    Upon completion of this video, you will be able to describe key features of Automatic Storage Management 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 Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Course Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Rating 4.6 of 76 users Rating 4.6 of 76 users (76)
Book Oracle on Docker: Running Oracle Databases in Linux Containers

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Backup & Recovery Options
Rating 4.6 of 31 users Rating 4.6 of 31 users (31)
Course Performance Tuning
Rating 4.5 of 32 users Rating 4.5 of 32 users (32)
Course Grid Infrastructure
Rating 4.4 of 34 users Rating 4.4 of 34 users (34)