ORACLE little knowledge architecture

Posted on 2009-11-20 filed under: Oracle (RSS) 19 views

As a regular dealings with the database software developers, has not been resolved to seriously sum up the database. Although most came into contact with open source, mysql, then install the linux once oracle, and that was the end of 2005 when the oracle that feels really heavy, I spent a total of 10G of space is not enough. Has been followed do not want to touch. But later in database development, or middleware used in most developing or oracle. Sense of each are not as flexible as a database, including the later sybase, informix, db2, Teradata, I would like to in-depth look at the database's internal structure and working principle, so spent the day yesterday, time to learn a bit oracle architecture.
rn

rn
ORACLE from the routine (Instance) and database (Database) composed of two parts. Routine is a set of memory structures and background processes collections. The memory structure includes data cache, redo log buffer and shared pool of three parts, these memory structures referred to as SGA (System Global Area); background process includes SMON, PMON, DBWR, CKPT, LGWR, ARCH and so on. The database is a collection of a set of OS files, which consists of data files, control files and redo log files. As for the detailed function of each block and each process uses, see the detailed documentation. And then there are the database works, to be continued
rn