Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> query delay

query delay

From: Steiner, Randy <Randy.Steiner_at_nyct.com>
Date: Thu, 5 Oct 2006 07:49:42 -0400
Message-ID: <25DB25D17E384D40B6F37EDA0DDD0C331DD98F@NYCTEXVS05.transit.nyct.com>


I am running 10gr2 on 4 blades, everything is running much faster than on the old server ......except;  

Periodically simple queries will take between 1 - 2 minutes. Simple as in

SELECT * FROM small_table.  

This delay does not happen all the time. I do not think this is an index issue. I think this is a RAC wait issue.    

I will occasionally (maybe once a day) get some of the following:  

   Metrics "Global Cache Blocks Lost" is at 25

   Metrics "Database Time Spent Waiting (%)" is at 57.65708 for event class "Cluster"    

Can anyone think of a way to investigate this?  

Thanks  

Randy              

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 05 2006 - 06:49:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US