Which two statements are true about shared server sessions?

Which two statements are true about shared server sessions?

Which two statements are true about shared server sessions?

A.
No Program Global Area (PGA) is allocated for shared server processes.

B.
User Global Area is stored in System Global Area (SGA).

C.
Shared SQL Area is allocated from Program Global Area (PGA).

D.
Private SQL Area is allocated from Library Cache.

E.
Large Pool is used for SQL work areas.

Explanation:
http://docs.oracle.com/cd/B19306_01/server.102/b14220/memory.htm (see library
cache)



Leave a Reply 5

Your email address will not be published. Required fields are marked *


temp1

temp1

the second answer is b

Anand

Anand

In question, they have asked for two statements then why there is only one correct answer?

Sunil Vora

Sunil Vora

Correct answers are B and D.

Wellington Marinho

Wellington Marinho

The Second B :

In a shared server environment, multiple client users share the server process. In this model,
the UGA is moved into the SGA (shared pool or large pool if configured) leaving the PGA with
only stack space.