Home » SQL & PL/SQL » SQL & PL/SQL » Materialized views - create and refresh times (10g Release, Windows Server 2003)
Materialized views - create and refresh times [message #320234] Wed, 14 May 2008 07:01 Go to next message
Messages: 59
Registered: May 2006

I am trying to find out all the materialized views present in the db, their create times, and their refresh times so that i can create a new mat view and set its create/refresh times appropriately so that it doesnt clash with the other ones and slow the system down. Anybody know where i would find this info?

Thanks in advance
Re: Materialized views - create and refresh times [message #320243 is a reply to message #320234] Wed, 14 May 2008 07:22 Go to previous message
Michel Cadot
Messages: 63930
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> desc dba_mviews
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 OWNER                            NOT NULL VARCHAR2(30)
 MVIEW_NAME                       NOT NULL VARCHAR2(30)
 CONTAINER_NAME                   NOT NULL VARCHAR2(30)
 QUERY                                     LONG
 QUERY_LEN                                 NUMBER(38)
 UPDATABLE                                 VARCHAR2(1)
 UPDATE_LOG                                VARCHAR2(30)
 MASTER_ROLLBACK_SEG                       VARCHAR2(30)
 MASTER_LINK                               VARCHAR2(128)
 REWRITE_ENABLED                           VARCHAR2(1)
 REWRITE_CAPABILITY                        VARCHAR2(9)
 REFRESH_MODE                              VARCHAR2(6)
 REFRESH_METHOD                            VARCHAR2(8)
 BUILD_MODE                                VARCHAR2(9)
 FAST_REFRESHABLE                          VARCHAR2(18)
 LAST_REFRESH_TYPE                         VARCHAR2(8)
 LAST_REFRESH_DATE                         DATE
 STALENESS                                 VARCHAR2(19)
 AFTER_FAST_REFRESH                        VARCHAR2(19)
 UNKNOWN_PREBUILT                          VARCHAR2(1)
 UNKNOWN_PLSQL_FUNC                        VARCHAR2(1)
 UNKNOWN_EXTERNAL_TABLE                    VARCHAR2(1)
 UNKNOWN_CONSIDER_FRESH                    VARCHAR2(1)
 UNKNOWN_IMPORT                            VARCHAR2(1)
 UNKNOWN_TRUSTED_FD                        VARCHAR2(1)
 COMPILE_STATE                             VARCHAR2(19)
 USE_NO_INDEX                              VARCHAR2(1)
 STALE_SINCE                               DATE

Previous Topic: compare columns between tables
Next Topic: tuning a sql
Goto Forum:

Current Time: Thu Oct 27 04:03:54 CDT 2016

Total time taken to generate the page: 0.14582 seconds