note of PGA
A program global area(PGA) is a memory region that contains data and control information for a server process.
Generally speaking, PGA contains Private SQL Area and Session Memory.
Private SQL Area :
pls notice:if a session is connected through shared server, it will be located in the server process's PGA.(either it is shared pool or it is large pool)
Session Memory:
to hold session variable and other infomations releted to the session.
for shared servers, there is only this part infomation located at PGA.
Generally speaking, PGA contains Private SQL Area and Session Memory.
Private SQL Area :
pls notice:if a session is connected through shared server, it will be located in the server process's PGA.(either it is shared pool or it is large pool)
Session Memory:
to hold session variable and other infomations releted to the session.
for shared servers, there is only this part infomation located at PGA.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/507279/viewspace-624002/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
请登录后发表评论
登录
全部评论
