olite server fetch size too low causing high cpu

 Hello,

We have an Oracle Lite mobile server (version 10g) on windows 2003.  The Olite server is connecting to an HPUX oracle database 10.2.0.4.   The HPUX server is experience a high cpu utilization.  I used a trace to see what going on.

One of the query I see is:

select id,create_tm,expire_tm,status_tm,status_msg,msg_type,msg_body from dm$device_queue where device_id=:1 order by id asc

In one of the transaction, it took 571 trips to the database in about 2 seconds fetching 10 rows at a time.

The above query was execute 46 times for a total of about 77 seconds.  Fetch size vary from 10 to  571.  Each fetch is 10 rows.