What is the difference between SGA and PGA?

devquora
devquora

Posted On: Feb 22, 2018

 

SGA (System Global Area)PGA (Program or Process Global Area)
It is a memory area assigned at the time of an instance start up.It is a memory area that conserve the information regarding the user session.
It is distributed as 40% of RAM size.It is distributed only 10% of RAM size.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Oracle DBA Interview Questions

    What do you understand by the Oracle?

    Oracle is a database company that stores the data. Oracle stores the data in a very definite way so that client can regain it in a multi-user condition...

    Oracle DBA Interview Questions

    What do you mean by Oracle Database?

    Oracle has the main theme of storing, creating and managing the database...

    Oracle DBA Interview Questions

    What do you mean by Oracle DBA and what is its role?

    DBA stands for the Database administrator. DBA has the proper rights that can add or remove new users...