Skip to Main Content
  • Questions

  • Script to kill sessions prior to shutdown

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Renee.

Asked: June 08, 2017 - 3:45 am UTC

Last updated: June 11, 2017 - 6:54 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

We have an issue during a monthly shutdown of the database in preparation to be refreshed, it hangs due to active calls. We then have to manually kill the sessions.
If possible, will you provide a script that can kill processes prior to a shutdown immediate?
There are multiple databases on this server and we only refresh one monthly.

Thank you very much.

and Connor said...

shutdown abort
startup restrict
shutdown immediate


Rating

  (1 rating)

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

Comments

Prefer not to use shutdown abort

Renee Bell, June 09, 2017 - 2:43 am UTC

Thank you for the suggestion, however, we prefer not performing a shutdown abort on a regular basis like that. Is there a script to kill active sessions?

Thanks
Connor McDonald
June 11, 2017 - 6:54 am UTC

I prefer that you *do* use shutdown abort.

There you go ... we're even :-)

Seriously...why an objection to shutdown abort ? That's equivalent to saying you have no confidence in the database.
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.