oracle server architecture diagram

Oracle Database 10g : 


Oracle Database 11g :



Thank you
Osama Mustafa

Comments

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

    ReplyDelete
  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.

    ReplyDelete

Post a Comment

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET