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

ORA-01031: Insufficient Privileges while creating mview in different schema.

Recently I faced very interesting issue, when user was complaining that he is getting (SCHEMA:TEST1) ORA-01031: insufficient privileges while creating materialized view under different schema (SCHEMA:TEST2) though TEST1 has DBA role assigned. For TEST1: SQL> select * from dba_sys_privs where grantee=’TEST1′; GRANTEE PRIVILEGE ADM —————————— —————————————- — TEST1 UNLIMITED TABLESPACE […]