RE: ORA-4043 On DBA_* Views If They Are Described In a Mount Stage

From: Tanel Poder <tanel_at_poderc.com>
Date: Fri, 12 Dec 2008 19:34:31 -0800
Message-ID: <FE0009F58FCD4EFCB8D2248B501A8D12@porgand>


Hi,

It's probably a bug, with caching of non-existence info in dictionary cache:

http://blog.tanelpoder.com/2008/08/18/case-study-on-some-rowcache-internals- cached-non-existent-objects-and-a-describe-bug/

Tanel.

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of William Wagman
> Sent: 12 December 2008 14:10
> To: oracle-l_at_freelists.org
> Subject: ORA-4043 On DBA_* Views If They Are Described In a
> Mount Stage
>
> Greetings,
>
> I came across something interesting today and I don't
> understand what is going on behind the scenes and hope
> someone can explain this to me.
>
> Upon opening a physical standby in read only mode we received
> an ORA-4043 upon attempting to query a DBA_ view. The
> solution, which works, is to either restart the database or
> flush the shared pool. Of course the underlying v$ views can
> be queried. I don't understand what is happening here and am
> hoping someone can explain to me what is going on behind the scenes.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 12 2008 - 21:34:31 CST

Original text of this message