Re: Query time out paramter in oralce

From: U C <umeshoracle_at_yahoo.com>
Date: 8 Nov 2004 21:45:11 -0800
Message-ID: <fd94e273.0411082145.579d63d6@posting.google.com>

umeshoracle_at_yahoo.com (U C) wrote in message news:<fd94e273.0411080300.2e056868_at_posting.google.com>...
> I am running a "SELECT COUNT(*) FROM MYTABLE" query on a very large Oracle
> table. My application stops responding (after about 15 seconds) because the
> query is taking too much time to return the query. I know other databases
> (MS Server) have a timeout parameter that can be set in the BDE. What can I
> do with Oracle? Which parameter do I have to set for the same.
>
> Thanks & Regards
> U C

My Application stops responding. Even if i need to set query time out parameter where do i do the changes for the same.

Please help me.

Waiting for your reply.

Regards
U C Received on Mon Nov 08 2004 - 23:45:11 CST