Transcript Oracle Veritabanı Mimarisi - Talip Hakan Öztürk`s ORACLE BLOG

VERİTABANI MİMARİSİ
Talip Hakan ÖZTÜRK
BANKASYA – ORACLE DBA
OCE, 10g OCA, 10g/11g OCP
http://taliphakanozturk.wordpress.com
Talip Hakan ÖZTÜRK
2000-2005 Azerbaycan Teknik Üniversitesi – Bilgisayar Müh.
BANKASYA - Oracle DBA
OCE, 10g OCA, 10g/11g OCP
Oracle Blogger
http://taliphakanozturk.wordpress.com
http://taliphakanozturken.wordpress.com
CETURK Oracle Forum Sorumlusu ve Editörü
http://www.ceturk.com
“Oracle Database 11g R2” Kitabının Yazarı
http://taliphakanozturk.wordpress.com
Gündem:

Oracle Veritabanı Mimarisi

Oracle Veritabanı Memory Yapısı

Oracle Veritabanı Process Yapısı

Oracle Veritabanı Storage Yapısı
http://taliphakanozturk.wordpress.com
Genel Oracle Veritabanı Mimarisi
Memory structures
Instance
System Global Area (SGA)
Process structures
Background processes
Storage structures
http://taliphakanozturk.wordpress.com
Database files
Oracle Database Memory Structure
PMON
SMON
D000
RECO
S000
Redo Log
Buffer
SGA
Shared SQL Area
P000
Database Buffer Cache
TL-812
Server
CKPT
DBW0
Data File
Raw Device
LGWR
ARCH
USER
Redo Log File
http://taliphakanozturk.wordpress.com
Oracle Background Processes
SMON
PMON
SGA
Database Buffer Cache
Redo Log
Buffer
Offline
Storage
Device
Dedicated
Server
Process
DBWR
User
Process
LGWR
ARCH
CKPT
Control
Files
Data
Files
http://taliphakanozturk.wordpress.com
Redo Log
Files
Redo Log ve Archive Log
Disk3
3a
3b
2a
2b
Disk4
Disk5
ARCH
Disk6
ARCH
http://taliphakanozturk.wordpress.com
ARC
ARC
LGWR
LGWR
4a
4b
LGWR
ARC
Disk2
1a
1b
LGWR
ARC
Disk1
Storage Structure
Mantıksal
Fiziksel
Database
Schema
Tablespace
Data file
Segment
Extent
Oracle data
block
http://taliphakanozturk.wordpress.com
OS block
Storage Structure
Segment
96K
Tablespace
Extent
Extent
24K
72K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
Database Blocks
http://taliphakanozturk.wordpress.com
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
2K
TEŞEKKÜRLER
Talip Hakan ÖZTÜRK
Bilgisayar Mühendisi
10g/11g Oracle Certified Professional
10g Oracle Certified Associate
Oracle Certified Expert
[email protected]
http://taliphakanozturk.wordpress.com
http://taliphakanozturken.wordpress.com