Oracle Architecture Overall Overview

This article has looked for an Oracle architecture diagram from the Internet for an overall description of Oracle 's Architecture

1 oracle database mainly has data files Database instance composition. Users are linked to server process through user processes parameter file If our database is in archive mode, oracle database will put   redo log files  write to   archived  Log files redo  log files 

2 Instance Introduction

When the database is started, the parameter file SPFile is read, and the parameter file is assigned aSystem globle Area (SGA),eachOracleThe data session connection is shared by the memory, forSGAcan also be divided intoShared Poolshared pool, which holds some data dictionary caches and a common library of functions. ForSGA, it is more important to haveDatabase Buffer Cache,Redo Log Buffer,Java Pool,Large Poolwait

ForPGAand theSGAAllocation of:PGA: Whenever there is aTCPConnectionOracle, it will produce aSessionsession, assigning aPGA. ForSGA: Yes All sessionsSessionshared memory, whenOraclethe database is initialized to allocate a shared memory area, which is started laterSGAthe size does not change

2 Database file: data Files,control files,Redo Logfiles. Data files are mainly used for storing business data files, and for control files,Redo Log Files Store Records of database operations, and if the database shuts down abnormally, it will read Redo log files to repair the database when it is started.

3 The database and instance of Oracle databases are communicated through a series of background. Different operations have different background processes to process

Oracle Architecture Overall Overview