What is System Global Area (SGA)

Q

What is System Global Area (SGA)? - Oracle DBA FAQ - Oracle Basic Concepts

✍: 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.

2007-04-21, 5196👍, 0💬

What is Program Global Area (PGA)
What is Program Global Area (PGA)? - Oracle DBA FAQ - Oracle Basic Concepts A Program Global Area (PGA) is a memory buffer that is allocated for each individual database session and it contains session specific information such as SQL statement data or buffers used for sorting. The value specifies t... 2007-04-21, 5090👍, 0💬

What Is a Parameter File
What Is a Parameter File? - Oracle DBA FAQ - Oracle Basic Concepts A parameter file is a file that contains a list of initialization parameters and a value for each parameter. You specify initialization parameters in a parameter file that reflect your particular installation. Oracle supports the fol... 2007-04-21, 5081👍, 0💬

What is a Database Schema
What is a Database Schema? - Oracle DBA FAQ - Oracle Basic Concepts A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with S... 2007-04-21, 5038👍, 0💬

What Is a Initialization Parameter File
What Is a Initialization Parameter File? - Oracle DBA FAQ - Oracle Basic Concepts An initialization parameter file is a text file that contains a list of initialization parameters. The file should be written in the client's default character set. Sample initialization parameter files are provided on... 2007-04-21, 4920👍, 0💬

What Is a User Role
What Is a User Role? - Oracle DBA FAQ - Oracle Basic Concepts A user role is a group of privileges. Privileges are assigned to users through user roles. You create new roles, grant privileges to the roles, and then grant roles to users. 2007-04-21, 4894👍, 0💬

What Is a Server Parameter File
What Is a Server Parameter File? - Oracle DBA FAQ - Oracle Basic Concepts A server parameter file is a binary file that acts as a repository for initialization parameters. The server parameter file can reside on the machine where the Oracle database server executes. Initialization parameters stored ... 2007-04-21, 4823👍, 0💬

What Is the Relation of a User Account and a Schema
What Is the Relation of a User Account and a Schema? - Oracle DBA FAQ - Oracle Basic Concepts User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as table... 2007-04-21, 4803👍, 0💬

What Is a User Account
What Is a User Account? - Oracle DBA FAQ - Oracle Basic Concepts A user account is identified by a user name and defines the user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects Default temporary tablespace for ... 2007-04-21, 4727👍, 0💬

What Is an Oracle Instance
What Is an Oracle Instance? - Oracle DBA FAQ - Oracle Basic Concepts Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and start... 2007-04-21, 4687👍, 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.