Oracle Database Architecture

Name: Oracle Database Architecture
Rating: 4.7 (4799 reviews)

Concepts of Oracle Database Architecture

Created byTISYA Software Solutions Private Limited, Ramkumar Swaminathan

Last updated 10/2018

English

What you'll learn

Understand the concepts of Oracle Database Architecture and Administration

Course content

1 section • 34 lectures • 3h 42m total length

Introduction to Computing Architecture3:48
Oracle Database Architecture Overview3:23
Oracle Database and Instance Components10:08
Oracle Instance Components8:22
Oracle Database Files9:06
What is the Listener?7:32
SELECT STatement processing6:20
DML Statement Processing9:06
DDL Statement Processing2:08
Instance Recovery5:59
Redo Logs8:53
Concurrent Transactions3:50
Oracle Instance Startup3:37
Oracle Instance Shutdown6:35
Introduction to Real Application Clusters5:01
Crash Recovery in Oracle RAC6:36
How do applications Connect to the Database5:10
Shared Server Configuration8:05
Connection Pool8:05
Connection Pool Optimization5:37
Global Temporary Tables16:01
Physical and Logical Structures6:13
Different Types of Tablespaces8:21
Read Consistency - Introduction3:28
Read Consistency - Statement Level6:01
System Change Number (SCN)2:44
Read Consistency - Transaction Level4:53
What are Data Blocks?3:28
Structure of Data Blocks5:34
Structure of a Row3:52
Space Management12:59
ROWID5:19
User and Schema4:30
User Profiles11:47

Requirements

Good understand in working with SQL

Description

In this course you will learn about the architectural components of Oracle Database. You will learn about the various Processes , Memory areas, Files that are involved in the Architecture of Oracle Database. This course will help you to get a deep understanding of the fundamentals of Oracle Database Architecture and will lay the foundation for skills on the job as a DBA and also help you in taking up the DBA certification.

Who this course is for:

Anyone who would like to learn about Oracle Database Architecture