I have a script that reads a lot of BLOBs using
DBMS_LOB.READ, in the process of converting them to files. While looking to improve the read speed, I looked at
The documentation on
DBMS_LOB.GETCHUNKSIZE says "Performance is improved if you enter read/write requests using a multiple of this chunk size."
The chunk size for BLOBs in the current database I am working with is 32528. But the max for
DBMS_LOB.READ seems to be 32000. Though I didnt find this anywhere specifically in the documentation, I encountered this limit practically. So I am unable to use this chunk size for my
Does anybody have a suggestion to improve the performance
DBMS_LOB.READ? Is the chunk size useful for reading only when it is less than 32000?