1751738
Members
5788
Online
108781
Solutions
>> But the oracle team want us to provide them complete analysis ,observations and recommendations from our team
Sorry, let me get this straight - Oracle is using more memory than it was previously and the Oracle team want YOU to tell THEM why... isn't that the wrong way round? If they are responsible for Oracle they should be telling you why that is!
85% memory utilisation on 11.31 doesn't sound serious to me. That said, if you are determined to get to the bottom of this, there are a few things your Oracle team need to look at:
- Has the SGA been changed in size recently (I would assume not as even the worst DBAs can mae a connection between resizing the SGA and using more memory!)
- Are there more active connections than there were - more connections generally means more shadow processes, which means more memory consumption - this is something they can tune though using PGA_AGGREGATE_TARGET
Either way, you as the sysadmin have very little control over how much memory Oracle uses - it's really for the Oracle team to tell you... I guess you could review the kernel configuration log ( /var/adm/kc.log ) tyo see if any changes to the kernel have happened recently, but there aren't many that could impact what happens to Oracle memory consumption - you might want to look for any changes to maxdsiz* or the shared memory parms.
HTH
Duncan
I am an HPE Employee
Sorry, let me get this straight - Oracle is using more memory than it was previously and the Oracle team want YOU to tell THEM why... isn't that the wrong way round? If they are responsible for Oracle they should be telling you why that is!
85% memory utilisation on 11.31 doesn't sound serious to me. That said, if you are determined to get to the bottom of this, there are a few things your Oracle team need to look at:
- Has the SGA been changed in size recently (I would assume not as even the worst DBAs can mae a connection between resizing the SGA and using more memory!)
- Are there more active connections than there were - more connections generally means more shadow processes, which means more memory consumption - this is something they can tune though using PGA_AGGREGATE_TARGET
Either way, you as the sysadmin have very little control over how much memory Oracle uses - it's really for the Oracle team to tell you... I guess you could review the kernel configuration log ( /var/adm/kc.log ) tyo see if any changes to the kernel have happened recently, but there aren't many that could impact what happens to Oracle memory consumption - you might want to look for any changes to maxdsiz* or the shared memory parms.
HTH
Duncan
I am an HPE Employee