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
How to use an explicit cursor without open statements?
How to open a cursor variable?
What is the difference between $oracle_base and $oracle_home?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is the max number of columns in an oracle table?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What would you do with an in-doubt distributed transaction?
What is the difference between translate and replace?
what is the scripts in data base?
How to use subqueries with the exists operator in oracle?
What is define in oracle?
How to put more than 1000 values into an oracle in clause?
Is the After report trigger fired if the report execution fails ?
What are operators in oracle?
What are the arithmetic operations?