oracle database architecture - en
TRANSCRIPT
Independent consultant
+11 years in IT+10 years with Oracle
Database ArchitectData Modeling and TuningSQL TuningDatabase TroubleshootingConsulting
Michal Šimoník© 2015
About me
Oracle Database
Architecture
Michal Šimoník© 2015
Introduction
Oracle Database
Architecture
● Oracle Database editions○ Personal edition○ Express edition○ Standard edition One○ Standard edition○ Enterprise edition
● Instalation○ ORACLE_BASE○ ORACLE_HOME
Michal Šimoník© 2015
Database
Oracle Database
Architecture
● Datafiles● Control file● Redo log files
● Initialization parameter file○ PFILE / SPFILE
● Password file
● Flash(Fast) Recovery Area○ Archived log files○ Backup files○ Flashback logs
● Automatic Diagnostic Repository○ Alert and tracelog files
Michal Šimoník© 2015
Logical database structure
Oracle Database
Architecture
Michal Šimoník© 2015
Physical database structure
Oracle Database
Architecture
● Important tablespaces○ SYSTEM○ SYSAUX○ UNDO○ TEMPORARY
Michal Šimoník© 2015
Memory structure
Oracle Database
Architecture
Michal Šimoník© 2015
Background processes
Oracle Database
Architecture
Michal Šimoník© 2015
Oracle Net
Oracle Database
Architecture
● The listener receives a request for client process connection● The listener starts dedicated server process. Server process inherits connection from the listener.● The client is now connected directly to the dedicated server.
Michal Šimoník© 2015
Oracle Net
Oracle Database
Architecture
● The listener receives a request for client process connection● The listener starts dedicated server process● The listener provides the location of the dedicated server process to the client● The client process connects directly to the dedicated server process
Michal Šimoník© 2015
Starting up a database
Oracle Database
Architecture
Michal Šimoník© 2015
Shutting down a database
Oracle Database
Architecture
Michal Šimoník© 2015
Transactions and Undo data
Oracle Database
Architecture
Michal Šimoník© 2015
Transactions and read consistency
Oracle Database
Architecture
Michal Šimoník© 2015
(NO)ARCHIVELOG - Backup and Recovery
Oracle Database
Architecture
Michal Šimoník© 2015
Thank you for your attention
Oracle Database
Architecture
Q&A