QUESTION 91

You configure your database Instance to support shared server connections.

Which two memory areas that are part of PGA are stored in SGA instead, for shared server

connection?

A. User session data

B. Stack space

C. Private SQL area

D. Location of t he runtime area for DML and DDL Statements

E. Location of a part of t he runtime area for SELECT statements

Correct Answer: AC

Section: (none)

Explanation：共享服務(wù)連接，必須保證所有的共享server進(jìn)程必須能夠訪問(wèn)會(huì)話的狀態(tài)，比如uga等，所以u(píng)ga必須要放在sga中，而不是pga中,而pga只是存放Stack space。如果分配了大池，則uga會(huì)放在大池中，而大池也是屬于sga的一部分。