Auditing when a view goes invalid?

From: Moritz Klein <mklein_at_students.uni-mainz.de>
Date: Thu, 03 Feb 2005 14:58:28 +0100
Message-ID: <36ep0jF503jfmU1@individual.net>

Hello NG,
first of all the system informations:

OS:	Windows 2003 Server
DBMS:	Oracle Enterprise Server 10.1.0.3

Is it possible to audit when a view goes invalid and log information of the actual sessions and maybe reason of this event?

I'm asking this because some views in the sys-schema became invalid multiple times. Recompiling just work without changes to the views, but that does not solve the problem.

Any hints are welcome.

Thanks in advance

Moritz Received on Thu Feb 03 2005 - 07:58:28 CST