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?
You have to join V$session and V$process to identify the OS process associated with the session on the database. I guess you are interested in SPID column of V$process view.
Each "application" connection can use a couple of tcp ports.
Try to check which connections use port 1521, and which anoters ports.
Then OS may keep connection after executing DB command disconnected.
netstat | grep 1521
Some applications open sockets for interact into one box (like UNIX loging)
Just exists BIG difference between network/soket connections and db connections.
Hi Shestakov
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?
Reply With Quote
Bookmarks