RE: ORA-4043 On DBA_* Views If They Are Described In a Mount Stage
- From: William Wagman <wjwagman@xxxxxxxxxxx>
- To: Tanel Poder <tanel@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Dec 2008 09:47:17 -0800
Tanel,
Thank you, great information.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: Tanel Poder [mailto:tanel@xxxxxxxxxx]
Sent: Friday, December 12, 2008 7:35 PM
To: William Wagman; oracle-l@xxxxxxxxxxxxx
Subject: RE: ORA-4043 On DBA_* Views If They Are Described In a Mount Stage
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.
--
http://www.freelists.org/webpage/oracle-l
Other related posts: