Monday, February 25, 2013

oracle server architecture diagram

Oracle Database 10g : 

Oracle Database 11g :

Thank you
Osama Mustafa


  1. Hi Osama,
    Could u give brief explanation of this flow which is presenting in diagram by words?

  2. Hi Osama Mustafa,

    One more question actually how DBMS manages or maintaining the physical and logical independence?

    We are saying that datafile is corresponds with tablespace. 1 datafile = 1 tablespace, But 1 tablespace = many datafiles.

    datafile is a physical storage whereas tablespace is a logical.

    Consider this scenario and explain it.