Quote:
Originally Posted by MensaWater
Don't worry about arguments you see online. Many technical people have differing opinions and some feel no need to sugarcoat the way they express them.
Was your 5.7 install running 32 bit or 64 bit Oracle? There can be issues with going from 32 bit to 64 bit if the binaries you're using aren't optimized for the latter as it can actually decrease performance.
You might want to run "sysctl -a" on both the original and the new system to see if there are kernel parameters that need tweaking. Usually Oracle's installation guides will suggest certain settings. Additionally you'd want to look at things like the size of the SGA vs the actual physical memory. I've seen DBAs try to create SGAs that used 99% of the memory because they'd didn't realize the OS and other associated proecesses (including some of the other Oracle binaries) might need memory of their own.
Is the Apache you had issues with the one that is installed with Oracle itself or the one that comes with the OS? Make sure you're looking at /etc/httpd.conf and conf.d for the latter and their analogues for the former.
|
Once again, am late with my replies. We had a nasty issue with the air conditioning and the TEST server had OS level issues. Let me answer your questions one after another
Was your 5.7 install running 32 bit or 64 bit Oracle? There can be issues with going from 32 bit to 64 bit if the binaries you're using aren't optimized for the latter as it can actually decrease performance.
=> We were always on 64 bit, hence the OS architecture was not the issue
You might want to run "sysctl -a" on both the original and the new system to see if there are kernel parameters that need tweaking. Usually Oracle's installation guides will suggest certain settings. Additionally you'd want to look at things like the size of the SGA vs the actual physical memory. I've seen DBAs try to create SGAs that used 99% of the memory because they'd didn't realize the OS and other associated proecesses (including some of the other Oracle binaries) might need memory of their own.
=> We have followed the Oracle suggestions for the kernel parameter settings (replicated over both Target and Source systems)
Is the Apache you had issues with the one that is installed with Oracle itself or the one that comes with the OS? Make sure you're looking at /etc/httpd.conf and conf.d for the latter and their analogues for the former.
=> This could be a real issue, I mean while we installed the OS afresh over the new target system, we chose the web server as an additional component.
Anyway, I rebuilt the OS, configured the kernel parameters, limits, and resolv files & the performance is much satisfactory. Still monitoring and if there is anything interesting coming up, will post
regards,