What is mean by Program Global Area (PGA) ?

Answer Posted / hariharanadh

It is a memory buffer that contains data and control information for server process
A PGA created when oracle server starts and deallocated
when server process down

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a parameter be passed to a cursor?

598


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1467


What is archive log in Oracle?

595


Explain the use of log option in exp command.

533


What is Segment Advisor in Oracle?

665






What are the ansi data types supported in oracle?

518


Where do we use decode and case statements?

555


What are the different types of database objects?

522


What is a relational database management system?

670


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1614


What are the advantages of oracle 12c?

553


What is a cursor variable?

568


What is user managed backup in Oracle?

609


Explain a synonym?

595


What is clustered table in Oracle?

639