G
Gareth Vincent
Guest
I'm curious in finding out if anyone has seen significant performance gains when working with the Prefetch parameters. One of the articles I stumbled across suggested using the following values as a starting point. -prefetchFactor 100 -prefetchNumRecs 100 Our data center is running multiple DB's on Sun Solaris with version 11.5. Clients are connecting via webclient. The last thing we want to do is decrease the performance to our end users. I suppose the question is how does one monitor the impact of these changes in a production environment.
Continue reading...
Continue reading...