| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> How to set appropriate arraysize for an OLTP application?
Dear All,
We are trying to tune SQL*Net using SDU,TDU and Arraysize parameters.
Could some one enlighten me how to calculate an optimal arraysize value for an application? I did search metalink. In our java applications few queries are returning 1 or 2 records and few of them returning 10s of 100s of records. Normally how does array size (in java prefetch) set in this kind of scenario?
Any help would be appreciated.
Thanks
Jay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: jaysingh1_at_optonline.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 21 2004 - 12:44:25 CST
 |
 |