What Is Pga?

1.	What Is Pga?
Answer» A PGA i.e Program Global Area is a memory region that contains data and CONTROL information for a server process.It is a memory created by ORACLE when a server process is started and it is non shared. Access to it is exclusive to that server process and is READ and written by Oracle code. The total PGA memory allocated by each server process associated to an Oracle instance is also known as AGGREGATED PGA memory allocated by the instance. A PGA i.e Program Global Area is a memory region that contains data and control information for a server process.It is a memory created by Oracle when a server process is started and it is non shared. Access to it is exclusive to that server process and is read and written by Oracle code. The total PGA memory allocated by each server process associated to an Oracle instance is also known as aggregated PGA memory allocated by the instance.

Answer»

A PGA i.e Program Global Area is a memory region that contains data and CONTROL information for a server process.It is a memory created by ORACLE when a server process is started and it is non shared. Access to it is exclusive to that server process and is READ and written by Oracle code.
The total PGA memory allocated by each server process associated to an Oracle instance is also known as AGGREGATED PGA memory allocated by the instance.

A PGA i.e Program Global Area is a memory region that contains data and control information for a server process.It is a memory created by Oracle when a server process is started and it is non shared. Access to it is exclusive to that server process and is read and written by Oracle code.
The total PGA memory allocated by each server process associated to an Oracle instance is also known as aggregated PGA memory allocated by the instance.

Discussion

No Comment Found

Related InterviewSolutions

How Do You Use A Pointer To A Function?
What Is Size Of Void Pointer?
Write A C Program To Find Size Of Structure Without Using Sizeof Operator?
What Is The Meaning Of Prototype Of A Function?
What Is Wild Pointer In C?
What Is Dangling Pointer In C?
Write A C Program To Swap Two Variables Without Using Third Variable ?
In C, What Is The Difference Between A Static Variable And Global Variable?
Is Using Exit() The Same As Using Return?
Why Does Pascal Matter? Is There Any Benefit To Using Pascal Functions?

What Is Pga?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment