Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 9i: Information about how frequent materialized views have been used

Oracle 9i: Information about how frequent materialized views have been used

From: Stefan Dipper <stefan.dipper_at_sap.com>
Date: Wed, 23 Jan 2002 16:14:47 +0100
Message-ID: <3C4ED367.960EC055@sap.com> 





Hi all,



is there a possibility to figure out in Oracle 9i on a view level how
frequent materialized views have been used ? Information of that kind is
quite important for a DBA to be able to decide whether the effort to
maintain the materialized view makes sense. I would like to avoid a
situation where there are hundreds of materialized views in a system and
nobody knows which are the important ones.



Regards,


Stefan
Received on Wed Jan 23 2002 - 09:14:47 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US