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

💬 2017-07-10 sasi: Nice tutorial..

About dba.FYIcenter.com Website
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administrators) and database application developers looking for database server management tips, database programming tutorials, career information, and so on. Just browse through the site, you will find the b... 2016-10-17, 3754👍, 0💬

Testing Area
What is test testing area for? The testing area is provided to allow visitors to post testing comments. 2016-10-15, 717👍, 1💬

💬 2017-07-10 Kumar Kedi: ascdfwtwert

Ways to End the Current Transaction in Oracle
How To End the Current Transaction in Oracle? There are several ways the current transaction can be ended: Running the COMMIT statement will explicitly end the current transaction. Running the ROLLBACK statement will explicitly end the current transaction. Running any DDL statement will implicitly e... 2019-09-04, 581👍, 0💬

Create a Test Table for Transaction Testing in Oracle
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements, you should create a testing table as shown in the script below: >cd (OracleXE home directory) >.\bin\sqlplus /nolog SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE... 2019-09-04, 528👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.