Re: strange permissions errors - memory corruption?
- From: Tanel Poder <tanel@xxxxxxxxxx>
- To: henry@xxxxxxxxxxxxxxx
- Date: Mon, 25 Oct 2010 23:56:33 +0300
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:
