Which three statements are true about System Global Area (SGA)?

Which three statements are true about System Global Area (SGA)?

Which three statements are true about System Global Area (SGA)?

A.
SGA contains shared memory structures for all Oracle processes running on a single server.

B.
Each server process has its own SGA.

C.
SGA is allocated automatically when a database is started.

D.
SGA is used to speed up queries by caching data blocks, program data, information about
database objects, and query results

E.
SGA is allocated automatically when a database is mounted.

F.
SGA is read and written by server and background processes.



Leave a Reply 3

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


kez

kez

SGA is allocated at nomount mode when parameter file is read