Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, oracle.

Asked: April 24, 2017 - 11:12 am UTC

Last updated: May 15, 2017 - 4:17 pm UTC

Version: 11.2.0

Viewed 10K+ times! This question is

You Asked

Hi team,

As i have seen i my db where active users are 15 and inactive session are 1500 so load become high then i kill the inactive session like

alter system kill session 'SID,SERIAL#' immediate; it works fine and load become normal.

So how to set the time then my inactive session will kill automatically so load become not high pls suggest.

dba_profiles all limit is unlimited.


Thanks

and Connor said...

Set an idle_timeout in a profile, and assign users to that profile.

Details here.

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:453256655431

https://asktom.oracle.com/pls/apex/f?p=100:201:106761202259195::NO:RP:P201_ID:9534557900346957352

Rating

  (4 ratings)

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

Comments

oracle oracle, May 09, 2017 - 7:12 am UTC

thanks for reply,

I have set as you recommanded idle_time=5 and user inactive till 5 min after that he tries to connect then that session will release from inactive session till that user inactive session remain in db as inactive.

I want after 5 min that inactive session kill and also release from db as inactive session killed.

Thanks
Connor McDonald
May 10, 2017 - 1:28 am UTC

Those inactive sessions will become "sniped", and cleaned up in due course.

An inactive session is not going to contribute to server load.

oracle oracle, May 10, 2017 - 1:42 am UTC

Thanks for reply,

As i have seen inactive session contribute the load in db server load become 50 to 80% then i just kill all inactive session and then load become normal within 5 mins.

So i want to kill inactive session with timeout.
Because idle_time is not killing inactive session.
Thanks
Connor McDonald
May 15, 2017 - 4:17 pm UTC

"As i have seen inactive session contribute the load in db server load become 50 to 80%"

Show me some proof of that...

oracle oracle, May 12, 2017 - 6:00 pm UTC

Please suggest.
Connor McDonald
May 15, 2017 - 4:16 pm UTC

"Because idle_time is not killing inactive session. "

They become SNIPED and resources will be freed and they'll be cleaned up over time

Not inactive

Jeff, May 16, 2017 - 4:39 pm UTC

If your "inactive" sessions are using 50% of resources, then they are not inactive.
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.