OraFAQ Forum: Server Administration » Kill inactive session

Home » RDBMS Server » Server Administration » Kill inactive session (Oracle 11.2.0.3 , Linux 2.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Kill inactive session [message #620251]

Wed, 30 July 2014 13:36

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

Report message to a moderator

Re: Kill inactive session [message #620252 is a reply to message #620251]

Wed, 30 July 2014 13:41

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

Report message to a moderator

Re: Kill inactive session [message #620254 is a reply to message #620252]

Wed, 30 July 2014 13:44

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

Report message to a moderator

Re: Kill inactive session [message #620255 is a reply to message #620254]

Wed, 30 July 2014 13:47

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!

Report message to a moderator

Re: Kill inactive session [message #620256 is a reply to message #620254]

Wed, 30 July 2014 13:53

John Watson
Messages: 8965
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?

Report message to a moderator

Re: Kill inactive session [message #620260 is a reply to message #620255]

Wed, 30 July 2014 14:13

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

Report message to a moderator

Re: Kill inactive session [message #620268 is a reply to message #620260]

Wed, 30 July 2014 14:43

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Previous Topic:	How to Partition existing Oracle 11g Table
Next Topic:	DISPLAY not set when invoke dbca

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 17:30:04 CST 2025