Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

packets being sent to and from the database and application servers are fully utilized.

looking for answer to above without having to hook up a traffic analyzer. Oracle Server has option to increase buffer size from 4096k to 32k. Was wondering if increasing size would speed communication between servers and maximize payload on gigethernet link . I guess I would need to somehow measure buffer status during transfer and how often it becomes empty. Open for suggestions. I know max gigeth packet size on ethernet is 1500 bytes and cisco supports a jumbo frame as well. I am network literate but not server literate. I do not have direct access to servers. Thanks and looking forward to reply.
1 Solution
Bill BachPresidentCommented:
Using Jumbo frames is something that really needs to be done on ALL devices on a subnet, including hosts, switches, etc. -- because if a packet was sent to a device that didn't understand the packet, it would choke.  As such, you're usually in for a major redesign, involving all devices, to jump to these larger frames.

As for the question of whether it will help you or not, this is another issue.  A network analyzer will be the only real way to tell how effectively things are working.  You can mirror a switch port to the analyzer and look at it from there.  For a database communications sequence like this, look for the percentage of "continuation" packets (i.e. those that do not have the PUSH bit set) compared to the overall packet count.  A percentage of 50% (in one direction) means that the database is using roughly two packets to send each data block (around 3K).  A higher percentage would indicate the chance that you CAN effectively use larger blocks.

Also, you may wish to note that the Oracle data block size and the network block size may NOT be related.  Note that TCP is a streaming technology.  This means that if Oracle builds a 20K data block to send to a client, the TCP stack will break it up into 15 or so packets of data -- and then stream them very rapidly across the wire without waiting for an ACK on every packet.  This will provide a performance gain on even a standard size Ethernet packet.  

Obviously, if you had enabled Jumbo frames, that same 20K block would only take three (9K) packets, so you would find even better performance, since the overhead (CPU and network interframe gap) on both sides of the link would be reduced by a factor or 7 or so.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now