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
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
Recommended Courses
1/12
About Author
Name
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox