Re: Query processing takes very variable time
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: Pradeep.Chetal@xxxxxxxxxxxxxx
- Date: Mon, 29 Dec 2008 18:53:00 +0100
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
Other related posts:
