Performance of retrieval of BLOB/CLOB values
We are migrating Informix database to Oracle database. The Informix database has some Images and large text files which are migrated to Oracle successfully.
But, when we are trying to retrieve the images from the Oracle database, it is taking more time (10%) when compared with Informix database.
Please let us know how can we improve this performance of retrieving BLOB data.
Appreciate any help on this issue.
Thanks and Regards,
Vamsi Mohan Harish