[ianlo]

Originally Posted by chrisplough

Ian,

In response to your questions:

1) I'm surprised that your maximum was set to 30 as 150 is usually the default value. On the OTM side, there is a negligible affect to this (possibly a few megabytes), but unfortunately there isn't a formula to help.

2) I believe that the client processes aren't included in the SGA but rather the PGA memory allocation and that their memory impact is minimal (until used). I'm sure that there is a formula to determine the memory requirements, but I unfortunately haven't seen it. If there is a DBA out there who can respond - I'd greatly appreciate it!

I can tell you that we've increased these settings on several OTM installations with minimal memory implications. The bulk of the memory usage will come from having more OTM processes run concurrently, due to the increase in DB connections available.

Also, while searching for an answer to #2, I did come across a brief article on tuning Oracle on AIX. It's a bit basic, but still it may help you:

Oracle AIX Tuning Optimization

I hope this helps!

--Chris

Hi Chris,

Excellent information! Will bring this back to my DBA and Infrastructure team!

Rep inbound!

Thanks!
Ian