Network Tuning (HP-UX) for Oracle DataGuard
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Network Tuning (HP-UX) for Oracle DataGuard

  1. #1
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103

    Smile Network Tuning (HP-UX) for Oracle DataGuard

    Hai.
    We would like to do some Network Throughout and Database Throughput tests to findout which is a better option between, HP Continuous Acess or Oracle DataGuard technologies. We are a major bank and we have about 10g R2 RAC (10.2.0.3) Databases using CFS and running on HP-UX 11i V2 Itanium in our Primary Site and we will be having 10 RAC DataGuards for these Primary RAC Databases.

    So, In our basic tests using LGWR SYNC/ASYNC and ARCH mode of LOG Transport methods, we found a major time difference in completeing a huge transaction. So, we would like to do some Network Tuning like increase TCP/IP Send Buffer Size etc. Please let me know if anyone did the similar exercises. Also, I want to know how to do that on HP-UX 11.23 Itanium.

    regards,
    Dileep Tallam.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Code:
    1. To monitor network statistcis and retransmitted data, 
       executet the following command:
       netstat -s -p tcp
    
       If the num of retransmitted data packets is high, 
       then your network is not having enough bandwidth.
    
    2.  The next command show all the tcp related parameters in 11.23
         ndd -get /dev/tcp ?
    
    3. The parameters important for peformance are:
        tcp_conn_req_max  
        tcp_xmit_hiwater_def  
        tcp_ip_abort_interval  
        tcp_rexmit_interval_initial  
        tcp_keepalive_interval

  3. #3
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103

    Question

    Hai Selvan.
    Thanks for your info. I know the commands to check the parameters for the network protocols using "ndd"

    I was actually looking for the changes to the Send and Receive Buffer Sizes:
    (Obtained using "ndd -h supported")

    tcp_recv_hiwater_max - Upper bound on TCP receive buffer size
    tcp_xmit_hiwater_max - Upper bound on TCP send buffer size


    Are you sure that we have to modify:

    tcp_xmit_hiwater_def

    Also, what are the maximum supported values and what are the other things they affect?

    regards,
    Dileep Tallam.

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Both parameters can be set to minimum of 512KB (524288 bytes).
    I do not remember the maximum values. Try with 1MB and do some benchmark with various values.
    Last edited by tamilselvan; 05-12-2008 at 08:01 AM.

  5. #5
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103
    Hai Selvan.
    Thanks for your info. The following are the current values that I took from my system:

    $ ndd -get /dev/tcp tcp_recv_hiwater_def
    32768
    $
    $ ndd -get /dev/tcp tcp_recv_hiwater_max
    1073725440
    $
    $ ndd -get /dev/tcp tcp_xmit_hiwater_max
    2147483647
    $
    $ ndd -get /dev/tcp tcp_conn_request_max
    4096
    $
    $ ndd -get /dev/tcp tcp_ip_abort_interval
    600000
    $
    $ ndd -get /dev/tcp tcp_keepalive_interval
    7200000
    $

    Any Comments? Also, I wanted to know just setting the Buffer Sizes will do? I mean are there any dependent parameters which need to be set to avoid congestion or buffer overflow kind of situations?

    regards,
    Dileep Tallam.

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