Query processing takes very variable time

From: Pradeep Chetal <Pradeep.Chetal_at_mformation.com>
Date: Mon, 29 Dec 2008 08:46:37 -0500
Message-ID: <B1C751058F4E7C41BD50130B0750DD93D6650B@mfusemail01.mformation.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.  


  • Pradeep

Pradeep Chetal
Sr. Director - Infrastructure Architecture

Mformation Technologies Inc.
Switchboard: +1 732 692 6200  

Visit WWW.MFORMATION.COM and see how the MFORMATION SERVICE MANAGER can help you to transform your business

Please consider the environment before printing


http://www.freelists.org/webpage/oracle-l Received on Mon Dec 29 2008 - 07:46:37 CST

Original text of this message