RE: ORA-4043 On DBA_* Views If They Are Described In a Mount Stage
- From: "Tanel Poder" <tanel@xxxxxxxxxx>
- To: <wjwagman@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Dec 2008 19:34:31 -0800
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of William Wagman
> Sent: 12 December 2008 14:10
> To: oracle-l@xxxxxxxxxxxxx
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
