Oracle Timeout Parameter

Mark Schenke

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Oracle Timeout Parameter

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?

Mark.

Mark Schenke

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Oracle Timeout Parameter

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?

Mark.

Mark Schenke

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Oracle Timeout Parameter

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?

Mark.

Other Threads

1. Oracle function: Return parameter in ADOStoredProc.Parameters?

2. Changing MSSQL TIMEOUT parameter.

3. Setting the BDE MSSQL Driver TIMEOUT Parameter In Code

4. MSSQL and TIMEOUT parameter

5. ?timeout parameters of ibconfig?

6. Pass arrary as parameter to Oracle Stored Procedure and get back Oracle cursor

7. ADO Command Timeout and ORACLE

8. Oracle Timeout

9. ORACLE Timeout

10. timeout for select operation in Oracle