Home » RDBMS Server » Server Administration » Kill inactive session (Oracle 11.2.0.3 , Linux 2.6)
Kill inactive session [message #620251] Wed, 30 July 2014 13:36 Go to next message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Hi ,

How to find inactive session older than 3 days and kill them all ?

Regards,
Srikanth
Re: Kill inactive session [message #620252 is a reply to message #620251] Wed, 30 July 2014 13:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Why you think this is needs to be done?
What problem are you really trying to solve?

query V$SESSION
Re: Kill inactive session [message #620254 is a reply to message #620252] Wed, 30 July 2014 13:44 Go to previous messageGo to next message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Hi Blackswan,
Quote:
Why you think this is needs to be done?
What problem are you really trying to solve?

This is based upon users complaint/request.

Regards,
Srikanth
Re: Kill inactive session [message #620255 is a reply to message #620254] Wed, 30 July 2014 13:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
it appears your users know more about Oracle DB internals than you do (which does not say much at all)

>This is based upon users complaint/request.
how do you or they know that any inactive session more than 3 days old ACTUALLY exists now?

Ready, Fire, AIM!
Re: Kill inactive session [message #620256 is a reply to message #620254] Wed, 30 July 2014 13:53 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
srikanth02 wrote on Wed, 30 July 2014 19:44
Hi Blackswan,
Quote:
Why you think this is needs to be done?
What problem are you really trying to solve?

This is based upon users complaint/request.

Regards,
Srikanth
Come on, Srikanth. No user has ever complained that "there are too many inactive sessions". No user even knows that there are inactive sessions. What was the actual complaint?
Re: Kill inactive session [message #620260 is a reply to message #620255] Wed, 30 July 2014 14:13 Go to previous messageGo to next message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Blackswan,

Quote:
how do you or they know that any inactive session more than 3 days old ACTUALLY exists now?

You are correct.Same question raised for me and i asked them but they said inactive session disappeared.

Hi John,
<Come on, Srikanth. No user has ever complained that "there are too many inactive sessions". No user even knows that there are inactive sessions. What was the actual complaint?

The complaint was to kill inactive sessions older than 3 days.When i asked them how you find out , they replied no issues now.

Regards,
Srikanth
Re: Kill inactive session [message #620268 is a reply to message #620260] Wed, 30 July 2014 14:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
The complaint was to kill inactive sessions older than 3 days


This is not a complaint and what is wrong is that they can know there are inactive sessions, this is not their business.

[Updated on: Wed, 30 July 2014 14:43]

Report message to a moderator

Re: Kill inactive session [message #620269 is a reply to message #620268] Wed, 30 July 2014 14:52 Go to previous message
srikanth02
Messages: 49
Registered: June 2014
Location: India
Member
Quote:
This is not a complaint and what is wrong is that they can know there are inactive sessions, this is not their business.

I agree with you Michel.I will ask all these questions to them if they come back again Smile

Regards,
Srikanth
Previous Topic: How to Partition existing Oracle 11g Table
Next Topic: DISPLAY not set when invoke dbca
Goto Forum:
  


Current Time: Thu Mar 28 07:12:03 CDT 2024