Downloaded 67 times
Uploaded byMichal Simonik
Oracle Database Architecture - EN
This document provides an overview of the architecture of Oracle Database. It discusses the different editions of Oracle Database, the files that make up an Oracle database including datafiles, redo logs and control files. It also describes the logical and physical structures of an Oracle database, including tablespaces, memory structures and background processes. Furthermore, it outlines how Oracle Net works to handle client connections and discusses transactions, undo data, read consistency and backup/recovery in an Oracle database.
Oracle Database Architecture - EN
- 1.
- 2. Independent consultant +11 yearsin IT +10 years with Oracle Database Architect Data Modeling and Tuning SQL Tuning Database Troubleshooting Consulting Michal Šimoník © 2015 About me Oracle Database Architecture
- 3. Michal Šimoník © 2015 Introduction OracleDatabase Architecture ● Oracle Database editions ○ Personal edition ○ Express edition ○ Standard edition One ○ Standard edition ○ Enterprise edition ● Instalation ○ ORACLE_BASE ○ ORACLE_HOME
- 4. Michal Šimoník © 2015 Database OracleDatabase 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
- 5. Michal Šimoník © 2015 Logicaldatabase structure Oracle Database Architecture
- 6. Michal Šimoník © 2015 Physicaldatabase structure Oracle Database Architecture ● Important tablespaces ○ SYSTEM ○ SYSAUX ○ UNDO ○ TEMPORARY
- 7. Michal Šimoník © 2015 Memorystructure Oracle Database Architecture
- 8. Michal Šimoník © 2015 Backgroundprocesses Oracle Database Architecture
- 9. Michal Šimoník © 2015 OracleNet 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.
- 10. Michal Šimoník © 2015 OracleNet 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
- 11. Michal Šimoník © 2015 Startingup a database Oracle Database Architecture
- 12. Michal Šimoník © 2015 Shuttingdown a database Oracle Database Architecture
- 13. Michal Šimoník © 2015 Transactionsand Undo data Oracle Database Architecture
- 14. Michal Šimoník © 2015 Transactionsand read consistency Oracle Database Architecture
- 15. Michal Šimoník © 2015 (NO)ARCHIVELOG- Backup and Recovery Oracle Database Architecture
- 16. Michal Šimoník © 2015 Thankyou for your attention Oracle Database Architecture Q&A