What is mean by Program Global Area (PGA) ?
- 9 Answers
- 19785 Views
- Bajaj, I also Faced
- E-Mail Answers
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 to export your connection information to a file?
How to delete a column in an existing table?
How to retrieve values from data fields in record variables?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to connect to the server with user account: sys?
What are the differences between lov and list item?
Name the three major set of files on disk that compose a database in Oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Where are the settings stored for each instance in oracle?
Explain what are the characteristics of data files?
Why packages are used in oracle?
Explain the use of parfile option in exp command.
Explain the use of control file?
Is it possible to insert comments into sql statements return in the data model editor ?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
