Group Discounts available for 3+ students and Corporate Clients

3 tier and 4 tire Architecture in Oracle DBA

3 tier Architecture




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 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 any 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




“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at, we will update the article in 24 hours.”

0 Responses on 3 tier and 4 tire Architecture in Oracle DBA"

Leave a Message

Your email address will not be published. Required fields are marked *


Please Enter Your Details and Query.
Three + 6