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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
