Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Array Fetch Size Alarm

Oracle client libraries support the ability to retrieve multiple rows from the database in a single operation. When more than one row is retrieved in a single SELECT, the amount of network traffic associated with SELECT operations is radically reduced and typically results in savings of up to 90% in elapsed time.

The Array Fetch Size alarm is raised when the array fetch size used by applications that access the database may be too low — an array fetch size lower than 20 may not be effective.

Addressing this issue usually requires a change in application code.

  • In PL/SQL, you may need to use the BULK COLLECT facililty.
  • In Java, you may need to use the setFetchSize() method.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation