Array Size

Hi,

Is there any method to enforce array size from the default 15 to somewhat higher may be 100 fetches from people soft application, we're seeing select sql running in loop which take more round trip 20000 to fetch 300000 rows processed with the elapsed time of 8 sec per fetch

Note tried indexes with all predicate columns.

SELECT  PROCESS_INSTANCE,

         BUSINESS_UNIT_PC,

         PROJECT_ID,

         ACTIVITY_ID,

         RESOURCE_ID,

         LINE_SEQ_NBR,

         DEBIT_CREDIT,

         DST_USE,

         INTER_ORG_LEVEL,

         CONVERSION_RATE,

         ORG_TO_BOOK,

         COMBO_STATUS,

         PROJECT_FLAG,

         IU_ANCHOR_FLG,

         CONTRACT_NUM,

         CONTRACT_LINE_NUM,

         CONTRACT_PPD_SEQ,

         ACCT_PLAN_ID,

         EVENT_NUM,