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

Compare and contrast between sql and sql server and explain its various functions?

540


What are group functions in oracle?

588


How do I connect to oracle?

562


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1661


How would you best determine why your MVIEW couldnt FAST REFRESH?

1438






What happens if you use a wrong connect identifier?

505


How do I call oracle stored procedures that take no parameters?

570


What is the difference between online and offline backups?

565


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1472


Are truncate and delete commands same? If so why?

658


How to create a new oracle data file?

563


What is the maximum limit on the number of columns in a table?

553


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1776


How can we find out the duplicate values in an oracle table?

614


how to join query for one source type is oracle another source type is sql server ?

1995