sqlnet contention
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sqlnet contention

  1. #1
    Join Date
    Nov 2000
    Posts
    157

    Unhappy

    Hi All,

    Previously the concurrent users are 44 and a few days back it increase to 520. The Library cache, Dictionary cache hit ratios, Database buffers and SGA are perfect. But the users are telling the performance is slow. There is something we tune the sqlnet.ora or Tnsnames.ora. I guess the problem is In networking area. Is there anything we can tune in sqlnet or in tnsnames to achieve the good performance.

    Please let me know in detail!!!!

    Thanks
    Ravi
    ravi

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Need information about:
    type of OS
    type of network protocols
    ur db works thru firewalls or not...
    type of client's application (C/S, WEB, terminals ...)
    A lot of questions.

  3. #3
    Join Date
    Nov 2000
    Posts
    157
    Hi,

    Here is the Info.:

    3-Tier :

    The OS : Windows 2000 advanced server

    Database : Oracle 8.1.7.2

    Application : Siebel 7.0.4

    Concurrent users : 520

    Network Protocol : TCP

    Database is NOT working through Firewalls

    Client Applications : Through WEB.

    If you need any specific Info please do let me know. I will provide all that.

    Thanks for the reply.
    Ravi
    ravi

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Uuuuu...
    U have many points of potential problems with perfomance :

    web_server(1) --(2)-->app_server(3) --(4)-->oracle_server(5)
    ------------------------------------------------
    1) perfomance of Web server with 520 connections
    2) traffiic between web and application server
    3) perfomance of App server with 520 connections (probably one of Java app server)
    4) traffiic between app and oracle server
    5) perfomance of oracle server with 520 connections
    ------------------------------------------------
    Try to implement following seq of actions:
    -- check terminal access (sqlplus) from db server box (u exclude sqlnet)
    then
    -- check terminal access (sqlplus) from application server box (u include traffic
    between Siebel application BOX ONLY and oracle server)
    and so on...
    ------------------------------------------------
    I don't thing that u have problems with sqlnet only.

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