Re: Oracle 12.2 logins hang

Hey Chris,
that's true. In addition you would see the blockers in case of the ("new") built-in password protection feature. I have blogged about this some time ago: https://blogs.sap.com/2012/11/10/oracle-wait-event-library-cache-lock-by-design-or-how-to-slow-down-the-database-engine/

However as mentioned you already created a systemstate dump and so you can follow the lock address / state object for further analysis.

Best Regards
Stefan Koehler

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

> Chris Stephens <cstephens16_at_gmail.com> hat am 29. Mai 2018 um 19:44 geschrieben:
>
> that's definitely not the case.  we can reproduce the issue on demand and know that invalid logins are not related.
>
> On Tue, May 29, 2018 at 11:38 AM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:
> > Do you have any locked accounts that are being attempted to be logged in to?  OR, heavy attempts with invalid passwords?
> >  
> >  There's a known issue where sessions that bang away at locked accounts (or with invalid passwords) cause a basic DoS -like scenario where no users can login.
> >  
> > You may want to turn on login audits to see if you're getting a lot of failed logins for a particular account.
> >  
> > As far as I know this problem still exists in 12c.
> >
> > High 'library cache lock' Wait Time Due to Invalid Login Attempts (Doc ID 1309738.1)
> >
> > Chris

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