3 tier and 4 tire Architecture in Oracle DBA

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. 

 

         

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

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