320 likes | 522 Views
Creating an Oracle Database. 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 Use DBCA to Create a database Configure a database Drop a database
E N D
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 • Use DBCA to • Create a database • Configure a database • Drop a database • Manage templates
Database Architecture • Data files Control files • Online redo log files • Archive log files • Parameter file • Password file
Exploring the Storage Structure Click on the links to view detailed information
Control Files • Contain physical database structure information • Multiplexed to protect against loss • Required to start the instance Control files
Redo Log Files • Record changes to the database • Multiplex to protect against loss Redo log buffer Log writer LGWR Group 1 Group 3 Group 2
Tablespaces and Datafiles • Tablespaces consist of one or more data files • Data files belong to only one tablespace Data file 2 Data file 1 USERS Tablespace
Segment Extents Data blocks OS blocks 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.
Oracle Instance Management SGA Shared Pool Streams Pool Large Pool Java Pool Database Buffer Cache Redo Log Buffer System Monitor SMON Process Monitor PMON Database Writer DBW0 Log Writer LGWR Check point CKPT Archiver ARC0
Oracle Memory Structures Server Process 1 Server Process 2 Back- ground Process PGA PGA PGA SGA Streams Pool Large Pool Shared Pool Database Buffer Cache Redo Log Buffer Java Pool
Oracle Processes Server Process Server Process Server Process Server Process System Global Area SGA System Monitor SMON Process Monitor PMON Database Writer DBWn Check point CKPT Log Writer LGWR Archiver ARCn Background Processes
Database Control Database control
Grid Control Grid control Management server Management repository Managed targets Agent Agent Agent Database control Database OS/third-party application Application server Application server control
Summary • In this lesson, you should have learned how to: • Describe the Oracle database architecture • Understand the instance architecture • Use the management framework • Use DBCA to • Create a database • Configure a database • Drop a database • Manage templates
Practice 3: Creating an Oracle Database • This practice covers creating an Oracle database by using DBCA.