session dropped via VPN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: session dropped via VPN

  1. #1
    Join Date
    Aug 2003
    Posts
    54

    session dropped via VPN

    the users have been experiencing problem with their session gto dropped and I trying to see how the connection behave so I issue the below command:

    select s.sid, n.name, s.value from v$sesstat s, v$statname n
    where s.statistic# = n.statistic# and
    s.statistic# in (182,183,184,185) and
    s.sid = 142 ;


    and I got:

    142 bytes sent via SQL*Net to client 2571
    142 bytes received via SQL*Net from client 2120
    142 SQL*Net roundtrips to/from client 43
    142 bytes sent via SQL*Net to dblink 0


    that's a very bad response, isn't it??? Is there any setting in the SQLnet.ora I can set so their session won't get dropped????

    please advise.

  2. #2
    Join Date
    Aug 2003
    Location
    Dhahran
    Posts
    33
    These statistics show that the sessions were very short but they do not tell us much about why the sessions got dropped.

    Do you have any other information about the sessions that were dropped? Did the users get any error messages at their workstations?

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