RE: dba_hist views going invalid

From: Powell, Mark D <mark.powell_at_EDS.COM>
Date: Thu, 12 May 2005 16:17:49 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395B8C7@usahm236.amer.corp.eds.com>

If you query the view do they automatically revalidate correctly? There was a patch that stopped the views from showing as invalid in OEM though naturally the views do still become invalid.

Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Barbara Baker Sent: Thursday, May 12, 2005 1:31 PM
To: oracle-l_at_freelists.org
Subject: dba_hist views going invalid

Oracle 10.1.0.3
Solaris 5.9

Several of my dba_hist views go invalid every night. I see a discussion of this on metalink, but no solution. (Both Mark Powell and John Kanagaraj contributed to the discussion on Metalink.)

Does anyone know what the resolution is?

Thanks for any help.
Barb
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu May 12 2005 - 16:22:35 CDT