焦ㄚ逃的生活筆記本~

一

1. User 透過Oracle client connect to Instance Server Process ( by dedicated/shared server)

2. server process 確認後會產生session，並規劃出一段PGA for 此次session (SQL Work Areas/Session Memory/Private SQL Area)

3. 規劃一段PGA後，會直接將SQL Work Area的資訊傳給Database Buffer Cache與 Redo Log Buffer

4. Database Buffer Cache 會將處理結果透過DBWn 寫到data file

二

Background Process: 1. PMON 2. SMON 3. RECO 4. MMON 5. MMNL 6.DBWn 7. CKPT 8. LGWR 9.ARCn 10. RVWR

Datafile: DBWn / CKPT

Control file: CKPT

Online Redo Log: LGWR

Archived Redo Log: ARCn

Flashback Log: RVWR

SGA= Shared Pool + Large Pool + Database Buffer Cache + Redo Log Buffer + Fixed SGA + JAVA Pool + Stream Pool

Shared Pool= Libary Cache(Shared SQL Area + Private SQL Area) + Data Dictionary Cache + Server Result Cache + Other + Reserved Pool

Large Pool= Free Memory + I/O Buffer Area + UGA + Request Queue + Response Queue