DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to cpmare netstat with v$session

  1. #1
    Join Date
    May 2002
    Posts
    12

    Question

    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?

    thanks,

    cathy
    DBA OCP 8i

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.

    Reddy,Sam

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

    [Edited by Shestakov on 08-08-2002 at 01:48 PM]

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    There you go quicker way of doing it...
    Reddy,Sam

  5. #5
    Join Date
    May 2002
    Posts
    12
    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?

    thanks,

    cathy
    DBA OCP 8i

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width