Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2010
    Posts
    3

    Unanswered: Oracle lag issue with a wan connection

    Hi everyone, I need help for a lag problem while using a wan connection.

    We are using smarteam, an application which use an oracle instance.

    We have heavy issue with one of our remote site.

    We have our main site which is where the oracle 10.2 DB is hosted and 3 remote site.

    All of the 3 remote sites have 10megabits connection, 2 of them have 6 users and the last one has 30 users.

    Only the 30 users site has performance issue with oracle.

    I'm not an expert with oracle, so the command I did try was a tnsping.

    I did the test simultanously on the 3 remote sites and the main site.

    I used the command tnsping "oracle instance" 500

    The 2 remotes sites with 6 users and the main site had the same performance between 10ms and 30ms reponse time.

    The one in problem has the following response :

    OK (20 msec)
    OK (10 msec)
    OK (20 msec)
    OK (10 msec)
    OK (20 msec)
    OK (20 msec)
    OK (3040 msec)
    OK (20 msec)
    OK (10 msec)
    OK (20 msec)
    OK (20 msec)
    OK (10 msec)
    OK (20 msec)
    OK (10 msec)
    OK (20 msec)
    OK (10 msec)
    OK (20 msec)
    OK (10 msec)

    Every time I try on the problematic remote site, there's a lot of long ping "2000 ms" or more.

    For this command, it takes around 8 seconds on the site with no performance issue and 40 seconds for the one with the problem.

    The software we are using "smarteam" is dependant largly on oracle performance and does create an impressive number of small SQL request while running.

    Do you think the problem can be caused by oracle ?

    If I try with a ping instead of a tnsping, I see no performance issue.

    The problem with the lag in the TNSping seem to be present mostly while the users are using the database, which again is not present on the other sites.

    Do you have any tips or idea?

    Thank you in advance.
    Last edited by jlachapelle; 01-18-10 at 12:36.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Do you think the problem can be caused by oracle ?
    >If I try with a ping instead of a tnsping, I see no performance issue.

    Are above done using hostname (DNS lookups) or IP#s?
    default DNS timeout is 30 seconds.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2010
    Posts
    3
    Quote Originally Posted by anacedent View Post
    >Do you think the problem can be caused by oracle ?
    >If I try with a ping instead of a tnsping, I see no performance issue.

    Are above done using hostname (DNS lookups) or IP#s?
    default DNS timeout is 30 seconds.
    I tried both way and I have the exact same result.

    The ip address is static on the server.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What is OS name & version of DB server & remote site "client"?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2010
    Posts
    3
    Quote Originally Posted by anacedent View Post
    What is OS name & version of DB server & remote site "client"?
    All the client are running windows XP Sp2 with oracle client version 10G Release2

    The server is running on Microsoft Windows Server 2003 R2 SP2 and the oracle is 10.2.0.1.0 version 10G Release2

Posting Permissions

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