We have a application server running on NT and point to the database on UNIX, we run the netstat command, it show over 1000 connections from the application to the UNIX, but when I query v$session, it only show 140 connections. how do I compare the two theory?
So, any connections not using port 1521, are left open because of the way network/socket desinged to work, it has nothing to do with the database application, is this right? Too many connection affect our UNIX server performance, what should I do to disconnect them? Should I reboot the application once a week?