stevetheski
asked on
oracle 11g on z/linux
Hi all,
first let me preface this question with... I do not yet have access to the server or database and i have only seen 1 awr report and a the output from df-k and du.
I have an 11g database running on z-linux and frequently the thing starts swapping to disk. The server has 72g of ram and it is not that heavily used. some things that jumped out at me are
pga_aggregate_target 6442450944 or 6g
sga_max_size 59055800320 = 55g
so the UGA is greater than the pga
another thing i noticed or rather didnt notice is the shmfs
I recall when installing 11g on redhat and using more than 25% of avail memory i had to set my shmfs or i would get memory_target not supported.
my question is on z-linux is the shmfs required as it is on redhat and is it acceptable to have the uga > pga
Thanks
Steve
first let me preface this question with... I do not yet have access to the server or database and i have only seen 1 awr report and a the output from df-k and du.
I have an 11g database running on z-linux and frequently the thing starts swapping to disk. The server has 72g of ram and it is not that heavily used. some things that jumped out at me are
pga_aggregate_target 6442450944 or 6g
sga_max_size 59055800320 = 55g
Instance Activity Stats - Absolute Values
Statistic Begin Value End Value
session pga memory max 3,872,656,816 3,125,364,624
session cursor cache count 1,279,656 1,432,730
session uga memory 63,353,187,248 63,755,218,768
opened cursors current 15,253 17,204
workarea memory allocated 172,094 261,297
logons current 488 539
session uga memory max 106,526,891,136 113,217,114,960
session pga memory 2,009,472,880 2,236,766,544
so the UGA is greater than the pga
another thing i noticed or rather didnt notice is the shmfs
I recall when installing 11g on redhat and using more than 25% of avail memory i had to set my shmfs or i would get memory_target not supported.
my question is on z-linux is the shmfs required as it is on redhat and is it acceptable to have the uga > pga
Thanks
Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks