ORACLE DATABASE 21C OVERVIEW

oracle database: overview

Eisen Picon - epicon@valmersys.comApril 30, 2021

AGENDA

memory structures

INTERACTING

innovation

MULTITENANT ARCHITECTURE

process architecture

cloud computing

storage architecture

architecture

ASM

database and asm

user accounts

connecting

01

oracle database innovation

Escribe un título

• Listado de puntos
• Listado de puntos
• Listado de puntos
• Listado de puntos
• Listado de puntos
• Listado de puntos

• Listado de puntos
• Listado de puntos
• Listado de puntos
• Listado de puntos
• Listado de puntos
• Listado de puntos

Esto es un párrafo de texto listo para escribir un contenido genial

Esto es un párrafo de texto listo para escribir un contenido genial

Escribe un título

Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat

Esto es un párrafo de texto listo para escribir un contenido genial

Esto es un párrafo de texto listo para escribir un contenido genial

Esto es un párrafo de texto listo para escribir un contenido genial

Esto es un párrafo de texto listo para escribir un contenido genial

02

enterprise cloud computing

Your data center

Cloud at Customer

Public Cloud

Exadata & Autonomous Cloud at Customer

Exadata Clout Service

Exadata Database Machine

Lorem ipsum dolor

Customer Data Center

Oracle Cloud Suscription

Customer Data Center

03

server architecture: overview

SERVER ARCHITECTURE

INSTANCE CONFIGURATIONS

04

connecting to the database instance

05

oracle database memory structures

MEMORY STRUCTURES

06

process architecture

PROCESS ARCHITECTURE

01

02

03

Daemon / Application processes

Database processes

user process

Server process: Connects to the Oracle instance and is started when a user establishes a sessionBackground processes: Are started when an Oracle instance is started

Is the application or tool that connects to the Oracle database

Networking listeners Grid Infrastructure daemons

03

02

01

PROCESS STRUCTURES

07

database storage architecture

STORAGE ARCHITECTURE

Online redo log files

Data files

Parameter file

Alert log and trace files

Archived redo log files

Control files

Backup files

Password file

Logical

PHYSICAL

database

Storage System

• SAN
• NAS
• Exadata
• File System
• NFS
• ASM

Data file

Tablespace

Segment

Extent

Oracle data block

TABLESPACES AND DATA FILES

08

database user account

• The SYSTEM and SYSAUX tablespaces are mandatory tablespaces that are created at the time of database creation. They must be online.
• The SYSTEM tablespace is used for core functionality (for example, data dictionary tables).
• The auxiliary SYSAUX tablespace is used for additional database components.
• The SYSTEM and SYSAUX tablespaces should not be used for application data.

USER ACCOUNTS

01

02

Each database user account has:

a schema

• Is a collection of database objects that are owned by a database user

• Has the same name as the user account

• A unique username
• An authentication method
• A default tablespace
• A temporary tablespace
• A user profile
• An initial consumer group
• An account status

01

02

• SYS:

1. Owns the data dictionary and the Automatic Workload Repository (AWR)
2. Used for startup and shutdown of the database instance

• SYSTEM: Owns additional administrative tables and views
• SYSBACKUP: Facilitates Oracle Recovery Manager (RMAN) backup and recovery operations
• SYSDG: Facilitates Oracle Data Guard operations
• SYSKM: Facilitates Transparent Data Encryption wallet operations
• SYSRAC: The account used to administer Oracle Real Application Clusters (RAC).

09

memory, processes and storage

MEMORY, PROCESES AND STORAGE

10

memory, processes and storage

MULTITENANT

01

02

03

All pluggable databases and the root

Pluggable database (PDB)

Multitenent container database (CDB)

• Database consolidated within a CDB
• Set of database schemas that appears logically to users and applications as a separate database

• Oracle Database 12c architecture that consolidates databases
• Has a database instance and database files at the physical level

• Background processes
• Shared/process memory
• Oracle metadata

03

02

01

11

AUTOMATIC STORAGE MANAGEMENT

• Is a portable and high-performancecluster file system
• Manages Oracle database files
• Manages application files withASM Cluster File System (ACFS)
• Spreads data across disksto balance load
• Can mirror data to protect against failures
• Solves storage managementchallenges

ASM

12

AUTOMATIC STORAGE MANAGEMENT

DATABASE AND ASM INSTANCE

ORACLE NET SERVICES

ORACLE NET LISTENER

MANAGEMENT TOOLS

01

04

02

03

SQL DEVELOPER

SQL*PLUS

ORACLE ENTERPRISE MANAGER DATABASE EXPRESS

ORACLE ENTERPRISE MANAGER CLOUD CONTROL

• Is a graphical user interface for accessing your instance of Oracle Database
• Supports development in both SQL and PL/SQL
• Is available in the default installation of Oracle Database

• Perform database management operations
• Execute SQL commands to query, insert, update, and delete data in your database

43

03

05

LISTENER CONTROL UTILITY

02

01

05

ASM TOOLS

01

02

ASMCA

ASMCMD

• Oracle ASM Command-Line Utility (ASMCMD): Used to manage Oracle ASM instances, disk groups, and volumes

• Oracle ASM Configuration Assistant (ASMCA): Used to install and configure Oracle ASM instances, disk groups, and volumes

01

02

¡Gracias!