What is mean by Program Global Area (PGA) ?

Answer Posted / nishi

It is area in memory that is used by a Single Oracle User Process. Whenever a server process is started a sertain amount of PGA memory is automatically allocated through the server process.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1808


What happens if the imported table already exists?

553


Point the difference between translate and replace?

578


What is the difference between a primary key & a unique key?

594


What is the usage of analyze command in oracle?

619






How to create a table index in oracle?

665


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1590


What privilege is needed for a user to delete rows from tables in another schema?

570


How to create a new oracle data file?

568


What is a nvl function?

570


How does Oracle guarantee data integrity of data changes?

1942


Differentiate between translate and replace?

635


How to use values from other tables in update statements using oracle?

576


Explain an integrity constrains?

711


Explain an exception and its types?

617