What is pga_aggregate_target?
- 1 Answers
- 677 Views
- I also Faced
- E-Mail Answers
Answer / Priti Vishnoi
PGA_AGGREGATE_TARGET is a parameter that determines the maximum amount of Program Global Area (PGA) memory available per server process for a single session. This value helps control the memory consumption of the PGA during parallel queries, sort operations, and other resource-intensive tasks.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the wait events in statspack report 'enqueue'?
What are database skills?
What is the easiest method to create a file on unix?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
Explain the term 'oracle grid architecture'?
What is the relation between database and instance?
While taking hot backup (begin end backup) what will happens back end?
What is the difference between cold backup and hot backup?
What is a junior dba?
What is a production dba?
How can you tell if an index on particular table is used or not used in 9i?
what does the no logging option do? Why would we use it?
Oracle General 
