Author Archives

Adityanath Dewoolkar

Multiple failed login attempts can cause high number of row cache lock wait events in 11g

From Oracle 11g, there is a new security enhancement that has potential of creating huge performance issues due to¬†failed login attempts through multiple sessions. Yesterday we faced this¬†issue on production database, all application users were complaining about slow performance especially while making new connections with database. After having quick check […]