Results 1 to 2 of 2

Thread: SDU Question?

  1. #1
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Exclamation Unanswered: SDU Question?

    hi all

    I have a branch connected to the server via lessd-line connection with 64 kbps (=8 KB) band-width, the SDU in TNSnames.ORA is the default 2048 (=2 KB).
    the question is :
    if I change the SDU to 8 Kb so the packet to transfer will contains more data so the query will be faster?

    thankx in advance

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    You might find this useful

    http://www.dba-oracle.com/art_builder_tns.htm

    Probably best to experiment with different values. You may also want to look at the OS settings for TCP/IP if thats what your using. Also you probably wont notice much difference unless you are returning a large amount of data.

    Alan

Posting Permissions

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