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