01 introducción a la arquitectura oracle
TRANSCRIPT
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
1/15
Copyright 2004, Oracle. All rights reserved.
Arquitectura Oracle
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
2/15
3-2 Copyright 2004, Oracle. All rights reserved.
Objectives
After completing this lesson, you should be able to do
the following:
Describe the Oracle database architecture
Understand the instance architecture Use the management framework
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
3/15
3-3 Copyright 2004, Oracle. All rights reserved.
Database Architecture
Data files Online redo log files
Password fileParameter file Archive log files
Control files
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
4/15
3-4 Copyright 2004, Oracle. All rights reserved.
Exploring the Storage Structure
Click on the links to viewdetailed information
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
5/15
3-5 Copyright 2004, Oracle. All rights reserved.
Control Files
Contain physical database structure information
Multiplexed to protect against loss
Required to start the instance
Control files
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
6/15
3-6 Copyright 2004, Oracle. All rights reserved.
Redo Log Files
Record changes to the database
Multiplex to protect against loss
Redo log
buffer
Log
writer
LGWR
Group 1 Group 2 Group 3
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
7/153-7 Copyright 2004, Oracle. All rights reserved.
Tablespaces and Datafiles
Tablespaces consist of one or more data files
Data files belong to only one tablespace
USERS Tablespace
Data file 1 Data file 2
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
8/153-8 Copyright 2004, Oracle. All rights reserved.
Segments, Extents, and Blocks
Segments exist within a tablespace.
Segments are made of a collection of extents.
Extents are a collection of data blocks.
Data blocks are mapped to OS blocks.
Segment Extents Datablocks
OS blocks
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
9/153-9 Copyright 2004, Oracle. All rights reserved.
Oracle Instance Management
System
Monitor
SMON
Database
Writer
DBW0
Log
Writer
LGWR
Process
Monitor
PMON
Archiver
ARC0
SGA
Java Pool
Shared Pool Large PoolStreams Pool
Database
Buffer Cache
Redo Log
Buffer
Check
point
CKPT
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
10/153-10 Copyright 2004, Oracle. All rights reserved.
Oracle Memory Structures
Java PoolDatabase
Buffer CacheRedo Log
Buffer
Shared Pool Large Pool
SGA
Streams Pool
Server
Process
1
PGA
Server
Process
2
PGA
Back-
ground
Process
PGA
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
11/153-12 Copyright 2004, Oracle. All rights reserved.
Oracle Processes
System
Monitor
SMON
Database
Writer
DBWn
Check
point
CKPT
Log
Writer
LGWR
Process
Monitor
PMON
Archiver
ARCn
Server
Process
Server
Process
Server
Process
Server
Process
System Global AreaSGA
Background Processes
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
12/153-13 Copyright 2004, Oracle. All rights reserved.
Data Dictionary
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
13/153-14 Copyright 2004, Oracle. All rights reserved.
Database Control
Database
control
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
14/153-15 Copyright 2004, Oracle. All rights reserved.
Grid Control
Gridcontrol
Management
server
Management
repository
Database
controlDatabase
OS/third-party
application
Application
server
Application
server control
Managed
targets
Agent AgentAgent
-
7/27/2019 01 Introduccin a la Arquitectura Oracle
15/153 16 Copyright 2004 Oracle All rights reserved
Summary
In this lesson, you should have learned how to:
Describe the Oracle database architecture
Understand the instance architecture
Use the management framework