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