OCI performance mistery

Hi, everybody.

I am new to oracle - i used sybase for many years. The problem i am experiencing is related to OCI access to oracle; we have a very simple and rather small table - just 8 columns (datatypes NUMBER, DATE and VARCHAR2). The table is just 2,000 rows. The table does not have indexes, though, since no column is a key (or any column can be a key).

Anyway, when i run sqlplus against this table, the responce time for a simple query (no join here) is wery short, the rows come almost immediately, which is expected. But when i run our application, which does the same exact query through OCI - it might take up to 30 sec for the same query, which is ridiculous.

I would appreciate any hint - i am quite sure we are doing something deadly wrong.

-- 


-----------------------------------------------------------------------

          ... occurrences like this will be few and far between ...

vlad_at_dkbfpny.com               Vlad Stavitsky          vlads_at_lvalue.com


-----------------------------------------------------------------------