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

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: