Re: Query processing takes very variable time
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Mon, 29 Dec 2008 18:53:00 +0100
Message-Id: <678F063C-543B-483C-97FD-585ECA1E05A0@gmail.com>
Date: Mon, 29 Dec 2008 18:53:00 +0100
Message-Id: <678F063C-543B-483C-97FD-585ECA1E05A0@gmail.com>
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.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.
>
> Thanks,
>
> -- Pradeep
>
-- http://www.freelists.org/webpage/oracle-l
- application/pkcs7-signature attachment: smime.p7s