How to Use the OCI Prefetch Number to Tweak the Server Performance

The OCI Prefetch Number tells the Oracle Client Interface how much records of a resultset it should fetch at once. Setting this value low increases the number of roundtrips to the Oracle-Server, setting it high increases the amount of memory OCI reserves and thus the baseload of PLANTA Server. One has to balance the Prefetch Number between those two parameters according to the individual system's latency and memory. As a reference you can use the charts below that are based on data created on a clean system with ~150000 records coming from database-server.

The Impact of OCI Prefetch Number on the Performance and Baseload of PLANTA Server

prefetch.png
Topic attachments
I Attachment History Size Date Comment
Pngpng prefetch.png r1 74.0 K 2010-07-28 - 12:33 The Impact of OCI Prefetch Number on the Performance and Baseload of PLANTA Server

         PLANTA project









 
  • Suche in Topic-Namen

  • Suche in Topic-Inhalten
This site is powered by the TWiki collaboration platform Powered by Perl