Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Pradeep kumar.

Asked: February 10, 2020 - 2:04 pm UTC

Last updated: February 11, 2020 - 4:07 am UTC

Version: 12.2.0.1

Viewed 1000+ times

You Asked

Dear Sir,

looking for extended knowledge for oracle lockes and its wait event like mutex,latches ,enqueue etc.
kindly share any good link for same or PDF will also do.

What are the causes for CBC latches one of the is HOT blocks , what are the others.

Many thanks for support.

Thanks
Pradeep

and Connor said...

Tanel Poder has an excellent presentation on this

https://tanelpoder.com/files/Oracle_Latch_And_Mutex_Contention_Troubleshooting.pdf

And although this particular blog has gone quiet, there is some great content on there

https://andreynikolaev.wordpress.com/



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