Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Arraysize over 5000

limorAug 29 2016 — edited Sep 20 2016

Hi,

I have created a webserver with python and cx_Oracle.

But now I have a problem to fetch the data. Sometimes my tiles have more than 5000 output rows. So in the cx_Oracle interface it is written that the default value for arraysize is 50. If I increase the value of 10.000 (cursor.arraysize = 10000) it works fine. But a value lower than 5000 needs milliseconds and a value bigger than 5000 needs some seconds. You can see the results in the picture

!overview.JPG

Furthermore it is written in the Oracle Docu:

_SET ARRAY[SIZE] {15 | n}

Sets the number of rows, called a batch, that SQL*Plus will fetch from the database at one time.Valid values are 1 to 5000. A large value increases the efficiency of queries and subqueries that fetch many rows, but requires more memory._

Does anyone have experience with sql queries more than 5000 output rows by using webframeworks (web.py, ...)???

So I think the results are regarding to this that over 5000 is not a valid value so the execution time is increased strongly...Is this right?

Is there a way to avoid this ?

This post has been answered by limor on Sep 20 2016
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 18 2016
Added on Aug 29 2016
14 comments
9,774 views