Oracle Analytics Cloud: Minimizing Impact on Query Performance Due to Network Latency

September 20, 2021 | 1 minute read
Ahmed Awan
Director, Customer Excellence, Analytics
Text Size 100%:

This blog is part of a series of best practice blogs for Oracle Analytics. 

Network latency increases when Oracle Analytics Cloud connects to a database on a different data center. You can minimize the negative performance impact from this higher network latency by reducing the number of network roundtrips between Oracle Analytics Cloud and your data source. By making fewer network roundtrips, you can reduce the response time of your database queries.

To achieve this, Oracle recommends that you increase the default bulk fetch row count and the size of the fetch buffer. You can modify both these settings in the data model file (RPD) for your Oracle Analytics Cloud.

Minimizing Impact on Query Performance Due to Network Latency

 

  • DEFAULT_BULK_FETCH_ROW_COUNT: Increase the bulk fetch row count value to 5000. As the number of rows in bulk fetches is limited by the size of the bulk fetch buffer, you need to increase the fetch buffer size too.
  • MAX_BULK_FETCH_BUFFER_SIZE:  Increase the buffer size to a large value, such as 10000000.

Note:  If the buffer size is not high enough, each bulk fetch contains fewer rows than expected by the DEFAULT_BULK_FETCH_ROW_COUNT. When network latency is high, this can degrade performance.

Ahmed Awan

Director, Customer Excellence, Analytics


Previous Post

Oracle Analytics Cloud on Gen 2: Features and Benefits

Oracle Analytics | 4 min read

Next Post


Transform your ideas into Oracle Analytics product features

Alexandria Toothman | 4 min read