Oracle - What Is System Global Area in Oracle

What Is System Global Area in Oracle

Q

What Is System Global Area (SGA) in Oracle?

✍: FYIcenter.com

A

The System Global Area (SGA) is a memory area that contains data shared between all database users such as buffer cache and a shared pool of SQL statements. The SGA is allocated in memory when an Oracle database instance is started, and any change in the value will take effect at the next startup.

⇒Oracle Database Basic Concepts

⇒⇒Oracle Database Tutorials

2016-10-17, 240👍, 0💬

Popular Posts:

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...

Using User Defined F...

Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...

Generating CREATE VI...

How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...

sys.server_principal...

How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...