Table 123 MVIEW_STATUS

Name

Type

 

 

MVIEWNAME

NOT NULL

 

VARCHAR2(30)

 

 

LAST_REFRESH_TIME

DATE

 

 

TOTALREFRESHTIME

VARCHAR2(32)

 

 

STATUS

VARCHAR2(10)

 

 

Views from Previous Releases

In this release, the materialized views were renamed, revised and in some cases removed. The following views were dropped from this release:

•MV_STORAGESYSTEMCAPSUMMARYVW

•MV_HOSTDETAILVW

•MV_UNITACCESSVW

The following table provides the views from earlier releases. Although you can still use these views for your reports created in previous versions, it strongly recommended you use the new views for any new report development. See the following tables for the corresponding new views.

Table 124 Views from Previous Releases

View Name

Corresponding New View

 

 

MV_ASSETCOUNTVW

No replacement

 

 

MV_ASSETSUMMARYVW

MVC_ASSETSUMMARYVW

 

 

MV_ASSETSUMMARYVW

MVC_ASSETSUMMARYVW

 

 

MV_HOSTSUMMARYVW ,

MVC_HOSTSUMMARYVW

MV_HOSTCONNECTIVITYV

 

W, MV_HOSTDETAILVW

 

 

 

MV_APPLICATIONVW

Information about applications is now in spread across several

 

materialized views.

 

 

MV_EVENTVW

MVC_EVENTSVW

 

 

MV_FILESERVERVW

Information about file servers is now spread across several

 

materialized views.

 

 

MV_HOSTSTORAGEALLOCA

Information spread across several materialized views, such as

TIONVW

MVC_HOSTSUMMARYVW.

 

 

Storage Essentials 5.00.01 User Guide 489