[askdba] sql response time too high

  • From: drumil narayan <drumilnarayan@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Fri, 24 Oct 2008 19:09:05 +0530 (IST)

Hi All,

on one of my ware house, in oem it is showing high sql response time.

when i looked it showing 

BEGIN wb_rt_service_control.wait( :1 , :2 , :3 ) ; END; and
BEGIN service_available(:1); END;
 
showing more time in thousands of seconds to complete.
 
what could be the issue..
 
thanks


      Add more friends to your messenger and enjoy! Go to 
http://messenger.yahoo.com/invite/

Other related posts: