Re: Oracle 12.2 logins hang

From: Stefan Koehler <>
Date: Tue, 29 May 2018 21:13:59 +0200 (CEST)
Message-ID: <>

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:

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:
Twitter: _at_OracleSK

> Chris Stephens <> 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 <> 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

Received on Tue May 29 2018 - 21:13:59 CEST

Original text of this message