[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.
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.
Other related posts:
