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

Popular Posts:

GO - Sending a State...

How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...

IF ... ELSE Statemen...

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

Unicode Character St...

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

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

"IF ... ELSE IF ..."...

How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......