Home Oracle Commands Oracle Data Dictionary
v$ Performance views

SUMMARIES

Although present in the dictionary (and some early beta's of V8) Oracle SUMMARYs were renamed as Materialised Views and so the SUMMARY dictionary views have been superseded by the corresponding MVIEWS (listed below.)

The SUMMARY views do not contain any data. 

 DBA_SUMMARIES        ALL_SUMMARIES        USER_SUMMARIES 
 DBA_SUMMARY_AGGREGATES  ALL_SUMMARY_AGGREGATES  USER_SUMMARY_AGGREGATES 
 DBA_SUMMARY_DETAIL_TABLES  ALL_SUMMARY_DETAIL_TABLES  USER_SUMMARY_DETAIL_TABLES 
 DBA_SUMMARY_JOINS    ALL_SUMMARY_JOINS    USER_SUMMARY_JOINS 
 DBA_SUMMARY_KEYS     ALL_SUMMARY_KEYS     USER_SUMMARY_KEYS
Related Commands: 
 DBA_MVIEWS           ALL_MVIEWS           USER_MVIEWS 
 DBA_MVIEW_AGGREGATES ALL_MVIEW_AGGREGATES USER_MVIEW_AGGREGATES 
 DBA_MVIEW_ANALYSIS   ALL_MVIEW_ANALYSIS   USER_MVIEW_ANALYSIS 
 DBA_MVIEW_DETAIL_RELATIONS ALL_MVIEW_DETAIL_RELATIONS USER_MVIEW_DETAIL_RELATIONS 
 DBA_MVIEW_JOINS      ALL_MVIEW_JOINS      USER_MVIEW_JOINS 
 DBA_MVIEW_KEYS       ALL_MVIEW_KEYS       USER_MVIEW_KEYS


Back to the Top

Simon Sheppard
 SS64.com