ORACLE 記憶體結構理解.

li__hl8888發表於2016-05-23

UGA:


USER SESSION STATE(including resource and security)  and  CURSOR_STATUS (running memory data,eg retrieve cursor data records).


PGA: STACK SPACE,可選(sort area size,session_state,cursor_status)


Large pool:MTS,parallel,部分備份和恢復,ORACLE XA



MTS:  userRequest process---- dispatcher001----request queue for all dispatchers ----shared servers----response queue for D000,D001----user dispatcher---user process.



BUCKET and buffer cache chain  $bh


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8568259/viewspace-2105380/,如需轉載,請註明出處,否則將追究法律責任。

相關文章