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, 538👍, 0💬

Popular Posts:

Import One Table bac...

How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...

Is SQL Server Transa...

Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...

Generating CREATE VI...

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

Unicode Character St...

How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...

EXECUTE - Executing ...

How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...