Collections:
What Is System Global Area in Oracle
What Is System Global Area (SGA) in Oracle?
✍: FYIcenter.com
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.
⇒ What Is Program Global Area (PGA) in Oracle
⇐ What Is an Initialization Parameter File in Oracle
2020-07-07, 1952🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...