Home » RDBMS Server » Server Administration » Old Tomcat inactive session in oracle 10g (Oracle 10g release 2 on linux 64 bit)
Old Tomcat inactive session in oracle 10g [message #343592] Wed, 27 August 2008 10:49 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
I am facing a problem of increasing inactive oracle sessions with tomcat, Old Oracle sessions with tomcat are visible with new one.

if somebaody did not restarted tomcat gracefully, then does Oracle keep the session connected or is there any way that whenever any one restarted tomcat abnormally, Oracle session can be killed.

I had restart the database to kill session.

[Updated on: Wed, 27 August 2008 10:51]

Report message to a moderator

Re: Old Tomcat inactive session in oracle 10g [message #343603 is a reply to message #343592] Wed, 27 August 2008 11:09 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
This is an Operating system/Tomcat problem; not an Oracle problem.
Oracle is oblivious to the fact that Tomcat was restarted as it should be.
Re: Old Tomcat inactive session in oracle 10g [message #343796 is a reply to message #343592] Thu, 28 August 2008 03:29 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Do not you think that Oracle database must kill the process automatically when OS process is being killed in linux.
Re: Old Tomcat inactive session in oracle 10g [message #343954 is a reply to message #343592] Thu, 28 August 2008 08:57 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
TOMCAT is NOT running on database server box. RIGHT?
How is Oracle to know or why should Oracle care about processes on some remote system?
Previous Topic: Table or view does not exist
Next Topic: Transporting Database template
Goto Forum:
  


Current Time: Sun Dec 04 17:01:19 CST 2016

Total time taken to generate the page: 0.08922 seconds