本帖最后由 Database_Sndy 于 2013-3-12 21:15 编辑
The UGA must be available to a database session for the life of the session. For this reason, the UGA cannot be stored in the PGA when using a shared server connection because the PGA is specific to a single process. Therefore, the UGA is stored in the SGA when using shared server connections, enabling any shared server process access to it. When using a dedicated server connection, the UGA is stored in the PGA.
Do not confuse a private SQL area, which is in the UGA, with the shared SQL area, which stores execution plans in the SGA.
根据以上信息当数据库连接模式是共享模式的时候UGA分配在SGA中,那么UGA的private SQL area也应该是存储在SGA中?
Table 14-1 Differences in Memory Allocation Between Dedicated and Shared Servers[td]Memory Area
|