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