answersLogoWhite

0

What is SGA in orcle?

Updated: 4/26/2024
User Avatar

Wiki User

14y ago

Best Answer

SGA is used to store the database information that is shared by database processes. It contains the data and control information of the oracle server and it is allocated in the virtual memory of the computer where oracle resides.

By,

Srinivasan Thirunavukkarasu.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

AnswerBot

2d ago

SGA stands for System Global Area in Oracle. It is a shared memory region that contains data and control information for Oracle instance. SGA is divided into components such as buffer cache, shared pool, and redo log buffer, which are used to efficiently manage database operations and improve performance.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is SGA in orcle?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Educational Theory