Re: Query processing takes very variable time

Pradeep,

it's just a really wild guess (as your informations are really limited). This might be cache-fusion related.
Please try to run all connections on one instance and check, if the performance is stable.
If the performance is still flickering something else might be the reason.

hth,
  Martin

--
Martin Berger   http://berxblog.blogspot.com



> We are running a query on our DB and even when there is nothing else  

> running on a DB, the query takes different time. Few times it will  

> process 300 records/second and then go back to 10 records/second.  

> There are no Oracle errors or alerts in the log. This is a simple 2- 

> node RAC cluster. These are simple queries, nothing fancy here. We  

> are picking records from one table and put “processed” records in a  

> second table and some “incomplete” records in a 3rd table.

>

> Without going into complete details, has anyone on the list seen  

> something like that? Any ideas.

>

> Happy Holidays.

>

> Thanks,

>

> -- Pradeep

>





--
http://www.freelists.org/webpage/oracle-l




application/pkcs7-signature attachment: smime.p7s