Home » RDBMS Server » Performance Tuning » PGA tuning - Oracle 9i
PGA tuning - Oracle 9i [message #65609] Sun, 07 November 2004 16:09
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.



 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

Previous Topic: database doesnt start
Next Topic: Too much LIO from single row table
Goto Forum:

Current Time: Tue Sep 29 06:36:38 CDT 2020