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

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Fri, 12 Dec 2008 14:09:31 -0800
Message-ID: <2A8185DC02A8CE4C8413E0A26A8A831A01DCAC7A9B@XEDAMAIL2.ex.ad3.ucdavis.edu>


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.


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
(530) 754-6208

Received on Fri Dec 12 2008 - 16:09:31 CST

Original text of this message