Converse agora com nosso suporte
Chat com o suporte

Spotlight on Oracle 10.10 - 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 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.

 

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação