3 tier Architecture

                                                                     3-tier architecture  

Inclined to build a profession as Oracle DBA Training? Then here is the blog post on, explore Oracle DBA Training

4 tier Architecture

We can add ‘n’ no.of architectures  

Library cache performs

  • Syntactical checking & whether SQL statement is valid or not like expressions messing from ok
  • Semantically checking whether the user is valid or not checks the privileges.
  • Data dictionary cache checks in base tables whether the table is available or not if available then the optimizer the oracle brain] checks whether the table has an index or not then the DDC makes an execution plan. 

 

4-tier Architecture

    updating db file       Redo log files

IF there is any update Then DBWR does 3 things i) updating db files ii) updating redo log files iii) updating index files Architecture files    

Inclined to build a profession as Client-server computing? Then here is the blog post on, explore Client-server computing