ARRAYSIZE 1 on NetWare 3.1 - ORACLE 6.0

We are trying to install an application using ORACLE 6.0 on a server running

   NetWare 3.1. The server has 48 MEG and has 50 users...The problem is:

When we do a SELECT query on a certain table, using the ORACLE defaults, we

   get a DBA-311 error (something like data size too large for buffer). This    was with MAXDATA = 20480 and ARRAYSIZE=20. The book recommended that we    raise the maxdata and/or lower the arraysize. We raised the MAXDATA=48000    and the query worked. THEN, (just to try it), we lowered the arraysize    to 1 (with maxdata still at 48000), and the server crashed. After reloading,     experimenting, etc., we find that other arraysizes work (even    2), but when we set it to 1 the server crashes.

Any clues as to how/why this happens? Any response is greatly appreciated,

   and I would love to here from people who are successfully using ORACLE    on a server running NetWare 3.1. We do not have a dedicated server for    ORACLE. The commands were issued from SQL*DBA.

Could someone clue me in a little bit on the ARRAYSIZE and MAXDATA

   parameters...I guess I don't understand what they control. I don't see    how lowering the arraysize could crash the server. Could it be that the    server is being overloaded with packets or something??? Any help would    be greatly appreciated!

If you need more info on our setup, etc., just let me know...Thanks!

Scott Cooper
(coops_at_s.ms.uky.edu) Received on Wed May 26 1993 - 03:06:01 CEST