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
How many file formats are supported to export data?
What is Java Pool in Oracle?
What is a data lock in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to experiment a data lock in oracle?
Explain do view contain data?
Can we store pictures in the database and if so, how it can be done?
How to update values in a table in oracle?
Why packages are used in oracle?
What is a table index?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is a connect identifier?
How to bring a tablespace offline?
Difference between open_form and call_form in oracle.