| pga memory [message #164919] |
Mon, 27 March 2006 10:46  |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
|
What happens to the user process who tries to connect and there is no more pga free to be allocated, because the pga_aggregate has already been allocated to other processes.
|
|
|
|
| Re: pga memory [message #165134 is a reply to message #164919] |
Tue, 28 March 2006 07:48  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
|
The pga_aggregate_target parameter is just a target, not an absolute maximum. Oracle can at times allocate more PGA memory (if needed).
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
