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
Can a parameter be passed to a cursor?
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.
What is archive log in Oracle?
Explain the use of log option in exp command.
What is Segment Advisor in Oracle?
What are the ansi data types supported in oracle?
Where do we use decode and case statements?
What are the different types of database objects?
What is a relational database management system?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What are the advantages of oracle 12c?
What is a cursor variable?
What is user managed backup in Oracle?
Explain a synonym?
What is clustered table in Oracle?