db_fetch_size

Question

Hi

I am not much familiar with XML Pserver.

I would like to know should I set higher db_fetch_size ? currently we set 20.

In weblogic JDBC pool setting we set all pools to Statement Cache Size:60

Any harm or improve if we set to  db_fetch_size=60

Thanks

Saresh-Oracle · Answer

Hi,

The Database Fetch Size property specifies the number of rows that are fetched from the database at a time. So I think there is no harm in increasing the value.

Reference: https://docs.oracle.com/middleware/12211/bip/BIPDM/GUID-A1B30871-6102-42A4-8F3C-2E3E89328A08.htm#BIPDM551

Regards,

Sareesh