cancel
Showing results for 
Search instead for 
Did you mean: 

SQL timeouts

Praveen Bezawada
Respected Contributor

SQL timeouts

Hi
When running oracle8 on HPUX11, what are the parameters which affect the SQL timeouts when the query is executed directly on the oracle server.
We need to select/delete/update large amount of data, we execute the queries in SQLPlus sessions started on the server, but sometimes our queries get timedout. What the parameter we need to check.
Thanks in advance
...BPK...
3 REPLIES
Alexander M. Ermes
Honored Contributor

Re: SQL timeouts

Hi there.
Try this parameter in sqlnet.ora :
SQLNET.EXPIRE_TIME
Purpose:
Determines time interval to send a probe to verify the session is alive

Default:
None

Minimum Value:
0 minutes

Recommended Value:
10 minutes

Example:
sqlnet.expire_time=10

Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Volker Borowski
Honored Contributor

Re: SQL timeouts

Hi,

basicly, there should be no timeout for the sql-statement itself, but for the wait-period to get a needed resource.

Do a
SELECT * FROM V$PARAMETER WHERE NAME LIKE '%waittime%';

try '%timeout%' and '%wait_time%' in addition and switch to the manual/doc-cd with this info.

If your transaction requires a specific resource, you might consider to allocate it at the begining of the transaction.

ALTER SESSION USE ROLLBACK SEGMENT MY_RSEG;
LOCK TABLE MY_TABLE;

With this, no timeout should occur, the risk for a ORA-1555 is smaller, but you might set up some users (they will receive the timeout).

Hope this helps.
Volker

Re: SQL timeouts

the timeout for a session can be enabled through profile(oracle profile).the parameters used to implement this functionality is
idle_time,connect_time

hope this helps.
jp