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 […]