Skip to Main Content
  • Questions

  • Kill Oracle Session when closing client on browser (Forms 11g)

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Victor Hugo.

Asked: January 13, 2017 - 6:44 pm UTC

Last updated: January 15, 2017 - 4:58 am UTC

Version: Oracle Forms 11g

Viewed 1000+ times

You Asked

Hey guys,

I am facing a problem, at the company I work for, we've noticed there were >60 active sessions without users "using" it.
Then, we've noticed it was being caused because of the way the user was closing the application. The user was clicking on the X button of the browser, instead of closing the application clicking on the exit door.

Is there a way or is there anyone who has already seen it? Does anyone know how to kill the session when the browser is closed without letting the application to know about it?

Cheers!
Victor

and Connor said...

Options you can consider

a) set FORMS_TIMEOUT to end their forms session after a certain amount of ianctivty
b) set a database profile to end sessions after a certain amount of inactivity.

Hope this helps.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.