Re: Query processing takes very variable time
Date: Mon, 29 Dec 2008 18:53:00 +0100
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.
-- Martin Berger http://berxblog.blogspot.comReceived on Mon Dec 29 2008 - 11:53:00 CST
> 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.
> -- Pradeep
- application/pkcs7-signature attachment: smime.p7s