Home What is Oracle? Oracle Training Tutorials for Beginners Difference Between Oracle 11g and 12c and 10g Import 12c Oracle Dump to 11g Ora 28001 The Password Has Expired Error Cache and Nocache in Oracle Sequence BR*Tools Documentation ORA-01455: Converting Column Overflows Integer Datatype Oracle Wait Events Interview Questions Difference Between Primary, Secondary and Clustered Indexes in DBMS Difference Between Hot and Cold Backup Oracle Partitioning Interview Questions Update Statement Works in Oracle Architecture Differences Between SAP HANA and Oracle Group Functions Ignore Null Values in Processed Column ORA-10458: Standby Database Requires Recovery Oracle Interview Questions

How to Explain Oracle Architecture?

Updated May 19, 2018

Hello Experts,
I am going to face an interview and preparing for that and as I am preparing I met with a problem that how to explain oracle architecture in interview? I am unable to explain it if anyone from you guys able to explain it then please let me know so that I can crack my interview easily.

Thanks in advance!

Comments

24 Aug 2015 6:24 pm Abhijeet Mudgal

For this use process server process then instance sga sga componant pga then background process then physical data files logical data files.

24 Aug 2015 6:25 pm Romil Tripathi

There are two types of oracle structures:
One is physical structure and logical structure. Physical structure contains 1. Data files. 2. Redo logs files. 3. control files.
Logical structure. 1. table spaces. 2. segments 3. extents 4. blocks. There are 4 types of memory areas are there. 1. SGA 2. PGA, 3. UGA, $. CGA. Oracle instance means the combination of backgroup process and SGA is called Oracle instance. Background process means. once the oracle instance started, there are 12 backgroud processes will start work. from them 5 will be continuesly work upto oracle shutdown. SMON, PMON,CHECKPOINT, DB WRITER, LOG WRITER. coming to shared pool, library cache, cursor shared pool etc. You have to go through. This is enough abt oracle architecture.