Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    8

    Unanswered: Set network packet size

    Hello,

    Again, i'm used to DBA'ing SQL Server, where setting the network packet size that the server uses to send data to the clients is done in a simple command. Now, I know where you can set the SDU and TDU in the TNSNAMES, but its my understanding that this is a client based setting, instead of a server based setting.

    Unfortunatly, the Oracle Metalink didnt provide much help either. Does anyone know of a way to set the network packet size on the Oracle server, if its possible?

  2. #2
    Join Date
    Oct 2004
    Posts
    145
    On the server side it is in the listener.ora

    From meta link
    #TNSNAMES.ORA
    ukp9930.world = (DESCRIPTION =
    (SDU=4096) #<-- SDU can be set from 512 bytes to 32Kb
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = tcp.world)
    (PROTOCOL = TCP)
    (Host = ukp9930)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SERVICE_NAME = rep1) ) )

    #LISTENER.ORA
    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS=
    (COMMUNITY= TCP.world)
    (PROTOCOL= TCP)
    (Host= UKP9930)
    (Port= 1521)
    )
    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = OFF
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SDU=4096) <---------- SDU has to match the setting in
    (SID_NAME = rep1) tnsnames otherwise it will negotiate to
    ) the lowest of the two sizes
    )

Posting Permissions

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