ORACLE 内存结构理解.
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博客 ” ，链接：https://blog.itpub.net/8568259/viewspace-2105380/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
