Using Linux Traffic Control to simulate latency and investigate fetch size for Oracle Database
Blog: Oracle BPM
Split-stack and WAN architectures have many advantages, but can also introduce latency. Fetch size determines the number of rows retrieved per database network call. This blog uses the Linux Traffic Control command to simulate latency and investigate the impact of fetch size on data warehouse and OLTP type workloads.