| PGA tuning - Oracle 9i [message #65609] |
Sun, 07 November 2004 16:09 |
Kenneth
Messages: 5
Registered: August 2002
|
Junior Member |
|
|
Dear all,
What can these numbers tell about the health of our database?
We found that the PGA memory keeps growing. The server has 2G RAM, 2G swap, shared_pool_size is 384M, large_pool_size is 2M, pga_aggregate_target is 320M.
Any help would be grateful.
Thanks!
NAME VALUE
---------------------------------------- --------------
aggregate PGA auto target 249,366,528
global memory bound 16,384
total expected memory 0
total PGA inuse 58,722,304
total PGA allocated 61,779,968
maximum PGA allocated 61,779,968
total PGA used for auto workareas 0
maximum PGA used for auto workareas 8,192
total PGA used for manual workareas 0
maximum PGA used for manual workareas 575,488
estimated PGA memory for optimal 0
maximum PGA memory for optimal 6,813,696
estimated PGA memory for one-pass 0
maximum PGA memory for one-pass 6,813,696
NAME VALUE
---------------------------------------- --------------
workarea executions - optimal 27,384
workarea executions - onepass 0
workarea executions - multipass 0
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
