What about the idea of having a dedicated listener just for dblink connections? I want to believe that might improve on the traffic for the default listener for the central db?
Having a dblink (private) listerner wouldn't hurt.
Don't think it will help a lot on the network traffic side of the equation - assuming listener will be attached to the same network card - but it may help having separate listener logs for troubleshooting purposes.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width