Re: strange permissions errors - memory corruption?

It may be that negative existence records get created in dictionary cache
(or remain there when they shouldn't stay there):

I once wrote a paper about it and you can use v$rowcache_parent to check
this:

http://www.tanelpoder.com/files/oracle_rowcache.pdf

--
Tanel Poder
New online seminars!
http://tech.e2sn.com/oracle-training-seminars


On Mon, Oct 25, 2010 at 10:12 PM, Henry Poras <henry@xxxxxxxxxxxxxxx> wrote:

> We are getting some very odd permissions errors on our development
> databases. Things run smoothly for a while, but when the errors appear, the
> appear for all new schema until we flush the shared pool.
>
> Our environment consists of developers each creating their own schema, with
> each schema looking fairly identical to each other schema. On completion of
> work, the schema is dropped.
>
> Every so often we see
>
>    dbms_aqadm.start_queue
>    *
> ERROR at line 10:
> ORA-06550: line 10, column 5:
> PLS-00201: identifier 'DBMS_AQADM' must be declared
> ORA-06550: line 10, column 5:
> PL/SQL: Statement ignored
>
>

Other related posts: