立即与支持人员聊天
与支持团队交流

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

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级