052-15

Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)
A. Shared SQL Area will be allocated in the shared pool
B. Shared SQL Area will be allocated when a session starts
C. Shared SQL Area will be allocated in the large pool always
D. The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always
E. Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool
F. The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter

私有区和共享区概念
　　PGA的结构可以分为三部分：Private SQL Area; Session Memory; SQL Work Areas
　　其中私有共享区，是存储在UGA中的，只有在非共享服务器模式下，才会储存在PGA中

 

转载于:https://www.cnblogs.com/Babylon/p/7941799.html