I like the 3 tier option personally... Which is actually what this is all about... so thanks for bringing it up... the client that is putting up the biggest fuss is utilizing a citrix solution... at this particular client's site they want to know what the big deal is with upgrading the oracle client on two citrix servers... In all honesty I don't like to "FIX" things that aren't broken and I have a sneaky feeling that if I upgrade the clients on these two servers that I will be up to my neck in calls about things not working correctly... this particular user doesn't have permission to access this new DLL... you know the drill... you are correct about the monkey thing though... it is such a big expense for me and my techs always manage to screw something up... if it isn't forgetting to remove the registry key before reinstalling the new client it is getting caught falling asleep... it is rediculous... anyhow... we have clients running personal oracle 8.05 with our software that haven't called in years... But in all honesty, if there is a difference in how these two clients handle sessions it may be helpful... currently we have a tough time with users powering off their machines... consequently suspending their oracle sessions... Oracle 9i is better at cleaning these up, but in some cases we are having to reboot servers once every few weeks... (although a bounce of the database is sufficient, we like to use this as an excuse to clear the server memmory)
Last edited by sirhaggus; 04-30-2004 at 04:04 PM.
Chester Ney
CODY Computer Services
System DBA