[askdba] Re: sql response time too high

  • From: Nisar Tareen <ntareen@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Fri, 24 Oct 2008 13:52:22 -0700 (PDT)

Check the sql trace  wether the Index been used properly. 
Check the locks and free locks. 
Check the sort area,   when the index been last created. 

Good Luck. 


From: drumil narayan <drumilnarayan@xxxxxxxxx>
To: askdba@xxxxxxxxxxxxx
Sent: Friday, October 24, 2008 9:39:05 AM
Subject: [askdba] sql response time too high

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..
Connect with friends all over the world. Get Yahoo! India Messenger.


Other related posts: