RE: SELECT in NULL state for a long time

2008-08-14 Thread Martin Gainty
Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Thu, 14 Aug 2008 17:35:00 +0530> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> Subject: Re: SELECT in NULL stat

Re: SELECT in NULL state for a long time

2008-08-14 Thread Krishna Chandra Prajapati
Record the query, execute and see the result. Make sure that you get the result. To me its seems that lots of request are comming and not full filled. Check the query for optimization. On Thu, Aug 14, 2008 at 5:17 PM, Vlad Shalnev <[EMAIL PROTECTED]> wrote: > Hi, > > OS - Solaris 10, 32 Gb RAM, m