Group Discounts available for 3+ students and Corporate Clients

3 tier and 4 tire Architecture in Oracle DBA

3 tier Architecture

 

Screenshot_17

 

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.

 

Screenshot_18

 

 

Screenshot_22

 

 

 

Screenshot_21

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

Screenshot_23

 

 

“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 info@tekslate.com, 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 *

    Support


    Please Enter Your Details and Query.
    Three + 6