Skip to Main Content
  • Questions

  • Can we kill the session which is holding latch cache buffer chain?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Aslam Baig.

Asked: May 02, 2019 - 2:45 pm UTC

Last updated: May 06, 2019 - 4:45 pm UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Dear Tom

Can we kill the session which is holding latch cache buffer chain by looking in to the
'select * from V$LATCHHOLDER;' view . If we kill that session What will be the impact to the instance?

Regards
MAB.

and Connor said...

I'd be investigating why you want to kill that session.

Anything holding a latch for an excessive amount of time should be perhaps traced and reported to Support before killing it.

Killing a *user* session will roll back any transactions they have open.

Do not kill an oracle background session - your session may terminate.

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 channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database