Re: Does oracle db serialize concurrent read-only SELECT ?

I wonder why you are getting 1,500 round-trips for 3,000 rows ? There may be some interesting new details of client libraries that are trying to save trips. Array fetching is the more efficient mechanism to use, in general, but implementation is language specific.

From your description it sounds as if you have MTS active, but not being used by
your tests. I'm afraid it would be too easy to confuse the issue of how to make sure that you go through MTS when I don't
know what your setup looks like at present. One point to bear in mind, though, if your client software is running on the same
machine as the server: the default Oracle installation usually results in client
connections bypassing the MTS setup
and using local IPC methods to connect.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Jung Tjong wrote in message <3ADDFFDF.E691A9EA_at_cisco.com>...


>Jonathan,

>

>I am using my ultra-60 machine again, and I had 3000 rows.

>The 1000 rows was when I tested it on a borrowed e-250.

>

>I'm not sure if I understand the arraysize and what I can do

>in the client to change this.

>In C++, I do execute, and fetch in a loop.

>In Java, I execute, get the ResultSet, and do next on the ResultSet.

>I'm fetching it row by row.

>