Re: Multi-threaded OCI Application Does Not Scale

Cary,

As Jonathan suggested, try to determine whether the delay is occuring at the client (OCI program) or server (database itself). You can look at V$SESSION_EVENT.
Alternatively, compare performance of OCI program with performance of INSERT AS SELECT or SQL*Loader - how long it takes to insert 100000 records, etc.

If the problem is at the database level, look at INITRANS, FREELISTS, size of extents, etc. Also, consider partitioning. Depending on the nature of your data, it may be possible to partition by such criteria that each incoming "chunk" of data belongs to one partition only. For example, we have application that inserts data from telco switches into Oracle database. As each incoming file contains data for only one switch, inserts for Sydney switch go into Sydney partition, inserts for Melbourne switch go into Melbourne partition, and so on, and do not interfere with each other. Received on Fri Jan 24 2003 - 00:10:03 CST