Home » RDBMS Server » Server Administration » inactive sessions (10.2.0.3 on HP-UX PA-RISC 64 bit)
inactive sessions [message #385196] Sat, 07 February 2009 05:45 Go to next message
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 messageGo to next message
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
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
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
Previous Topic: Problem when shutdown improperly
Next Topic: Move an entire instance
Goto Forum:
  


Current Time: Sat Nov 09 16:37:32 CST 2024