Re: Query time out paramter in oralce

From: Nisar Tareen <ntareen_at_yahoo.com>
Date: 8 Nov 2004 09:45:52 -0800
Message-ID: <6134f1ca.0411080945.c5e81df@posting.google.com>

Check your profile, may be on your account you have some sort of limitation of i/o or resources.

Normally, I had couple of million of records in my tables count(*) dose not take such a time. HOw big is you table, and when you say it large table. May be U need a tunning of your database. It is not clear that the application stop after 15 seconds. How do u notice or know it stop.

Nisar Tareen

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
Received on Mon Nov 08 2004 - 11:45:52 CST