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

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 the runtime area for DML and DDL Statements

E.
Location of a part of the runtime area for SELECT statements

Explanation:
* PGA memory allocation depends on whether the database uses dedicated or
shared server connections.

Note:
* System global area (SGA)
The SGA is a group of shared memory structures, known as SGA components, that contain data
and control information for one Oracle Database instance. The SGA is shared by all server and
background processes. Examples of data stored in the SGA include cached data blocks and
shared SQL areas.
* Program global area (PGA)
A PGA is a memory region that contains data and control information for a server process. It is
nonshared memory created by Oracle Database when a server process is started. Access to the
PGA is exclusive to the server process. There is one PGA for each server process. Background
processes also allocate their own PGAs. The total memory used by all individual PGAs is known
as the total instance PGA memory, and the collection of individual PGAs is referred to as the total
instance PGA, or just instance PGA. You use database initialization parameters to set the size of
the instance PGA, not individual PGAs.
Reference: Oracle Database Concepts 12c

Show Hint

← Previous question

Next question →

Leave a Reply 20

Sunil

The question says which Two memory areas? The answer was given for only one.

The second answer is User Session Data.

Correct options are: A and B

Mahrukh Khan

Answer should be A and C

Ledeboer, Jeroen

A is correct: To get around this problem, a shared server session stores most of the
session data in the shared pool, rather than in the PGA. Then whenever a shared server
picks a job off the common queue, it will go to the SGA and connect to the appropriate
block of memory to find out the state of the session.
B is wrong: EXAM TIP In shared server, what PGA memory structure does not go into
the SGA? The stack space.

maha

Correct Answer: A, E
http://docs.oracle.com/cd/B19306_01/server.102/b14220/memory.htm
Oracle creates the runtime area as the first step of an execute request. For INSERT, UPDATE, and DELETE statements, Oracle frees the runtime area after the statement has been run. For queries, Oracle frees the runtime area only after all rows are fetched or the query is canceled.

The location of a private SQL area depends on the type of connection established for a session. If a session is connected through a dedicated server, private SQL areas are located in the server process’s PGA. However, if a session is connected through a shared server, part of the private SQL area is kept in the SGA.

http://tinyurl.com/kd95v9r

Hi! I just would like to offer you a big thumbs up for the great info you have got right
here on this post. I’ll be coming back to
your blog for more soon.

clash of clans hack android

May I just say what a relief to discover an indeividual wwho really knows
what they are discussing oon the net. You actually
know how to bring a prroblem to light and make it important.
More peopole should read tbis and understand this side of yourr story.

I can’t believe you aren’t more ppopular ecause you
definitely possess the gift.

http://imgur.com/sxlXDSJ

I am regular visitor, how are you everybody?
This paragraph posted at this web site is in fact pleasant.

Gaz Mort

miche

bar s leaks head gasket repair

I blog frequently and I really thank you for your content.
This great article has really peaked my interest.
I am going to bookmark your site and keep checking for new information about once per week.
I subscribed to your RSS feed too.

stackable folding chairs

Hello I am so excited I found your blog page,
I really found you by accident, while I was searching on Yahoo
for something else, Anyways I am here now and would just like to say thanks for a tremendous post and a all round interesting blog (I also
love the theme/design), I don’t have time to read through it
all at the moment but I have saved it and also added your RSS feeds, so when I have time
I will be back to read more, Please do keep up the awesome b.

clear acrylic chairs

Wow, fantastic weblog format! How long have you ever been blogging for?
you made running a blog look easy. The total look of your site is great, as
neatly as the content material!