OCIStmtFetch2 performance on Solaris
We have some queries in our application fetching 200.000 rows from a 47-row table.
The query completes within approx. 28 seconds.
Our test client application is a simple C++ OCI based doing nothing with the received data.
The client process uses lots of CPU while running, while DB server processes uses almost no CPU.
Oracle is version 10.2.0.4.
We have monitored with SQL trace / tkprof and got the following output from tkprof:
select *
from
nwdb.tp where rownum <= 200000
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1981 5.45 5.47 0 8016 0 200000
------- ------ -------- ---------- ---------- ---------- ---------- ----------