Oracle 11g Architecture Oracle – PGA+ Instance + DB files Instance – SGA + BG Instance —SGA and BG SGA — Shared Pool, Database buffer cache, Redo log buffer cache, large pool, Java pool & Streams pool. Shared Pool — Most recently executed statements and definitions. Data Dictionary cache & Library cache Data Dictionary — most recently used definitions, including table, index & privilege. Library cache — most recently used SQL & PL/SQL statements Shared SQL area & Shared PL/SQL area Database buffer pool — It stores a copy of data block. Default, keep & Recycle Redo log buffer pool — it stores all the changes made to the…