Precompilers and OCI (MOSC)

MOSC Banner

How to change fetch array size Pro*COBOL

edited Jul 7, 2016 5:01AM in Precompilers and OCI (MOSC) 1 commentAnswered

Hi All,

I was wondering if anyone out there knew anything about Oracle Pro*Cobol?

We’ve inherited an application that is displaying some performance problems. An example of one is a full table scan report which returns quickly in the database, but very slowly when run from the app server.

If we mess with the array size in SQL plus on the app server, e.g SET ARRAY 5000, then we can get the performance to be broadly similar.

My question is, how do I set the array size when using Oracle Pro*Cobol?

Thanks

Chris

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center