SQL timeouts

[Praveen Bezawada]

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...

[Alexander M. Ermes]

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

[Volker Borowski]

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

[Jayaprakash_1]

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.