| SQL*Net Message from client [message #64866] |
Sat, 21 February 2004 02:54  |
Joe Fabiano
Messages: 1
Registered: February 2004
|
Junior Member |
|
|
I turned sql tracing on by executing:
alter session set events '10046 trace name context forever, level 8'
Then executed: select sysdate from dual;
8 hours later within the same session I execute:
select sysdate from dual;
Then I disconnected and ran tkprof with waits=yes option. I was surprised that the
SQL*Net Message from client wait showed only 21 minutes. I would have expected an 8 hour elsapse time. Any ideas?
|
|
|
|
| Re: SQL*Net Message from client [message #64868 is a reply to message #64866] |
Mon, 23 February 2004 01:10  |
Frank Naude
Messages: 4595
Registered: April 1998
|
Senior Member |
|
|
Hi,
Maybe there were some communications between the client and DB. For example, when using DCD (Dead Connection Detection). View your SQLNET.ORA file to see if you've set SQLNET.EXPIRE_TIME.
When DCD is used, the server will "probe" the client every SQLNET.EXPIRE_TIME minutes to see if it is still there.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
