inactive sessions [message #385196] |
Sat, 07 February 2009 05:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
seema.taunk
Messages: 96 Registered: October 2006
|
Member |
|
|
Dear all,
We want to kill inactive sessions which are idle for 5 mins. For that we have set idle_time=5 in profile & resource_limit=true.
1> Client access table of above database using database link.
If client session is idle for more than 5 mins, it went into sniped state.
2> When client fire query again in same session, it got killed.
But I have question:
Client is connected to its local database .
If he need remote database table, he query it using database link & we got sid,serial# in server for that session which is different than his local database sid,serial#.
When session went into sniped state at server side for that user, his own session(in which he is connected to local database) is in inactive state.
connect test1
password :
desc k1@dblink
where k1 is table of krish user.
at server _>
SID SERIAL# SECONDS_IN_WAIT USERNAME STATUS
---------- ---------- --------------- ---------- --------
1044 41402 426 KRISH SNIPED
at client ->
SQL> /
SID SERIAL# USERNAME STATUS
---------- ---------- ------------------------------ --------
255 9053 TEST1 INACTIVE
When he fire query again to access remote table using database link, his session at server side got killed ( sid 1044) , but his own session in which he is querying remote table also got killed( sid 225).
Actually, only his session at server side should got killed since it is in sniped state.
Why his local database session ( sid-225)is also got killed ?
[Updated on: Sat, 07 February 2009 05:47] Report message to a moderator
|
|
|
Re: inactive sessions [message #385200 is a reply to message #385196] |
Sat, 07 February 2009 07:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Quote: |
We want to kill inactive sessions which are idle for 5 mins
|
1) Why?
2) Can the client software handle killed sessions and does it do a graceful re-connect or would it just crash? In which case killing the sessions would probably be a bad idea.
|
|
|
Re: inactive sessions [message #385203 is a reply to message #385196] |
Sat, 07 February 2009 10:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
It is not clear if you set resource_limit and idle_time in local or remote database.
Also are the databases the same version?
Regards
Michel
|
|
|