Re: Weird Situation (12.1.0.2 Exadata Cloud _at_ Customer) - Blocking locks with no blocker

Hey Chris,

> I cannot figure it out and its driving me a bit bonkers.

... so do a systemstate dump when the issue occurs again - crazy system or not if you wanna know what is going on :-)

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Chris Taylor <christopherdtaylor1994_at_gmail.com> hat am 1. April 2020 um 16:18 geschrieben:
>
>
> Nope, but I saw a blog or oracle support document on that issue as well.   
>
> I cannot figure it out and its driving me a bit bonkers.  It only started in the last couple of weeks and the db has been bounced since it was first noticed.
>  
> I really don't want to take a system state dump on this crazy system  and was hoping there was a way to debug a session individually.
>  
> Chris

--
http://www.freelists.org/webpage/oracle-l