Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_SUMMARY_JOINS

Data Dictionary View 

Columns
   ___________________________
 
   OWNER
      Owner of the summary
   SUMMARY_NAME
      Name of the summary
   DETAILOBJ1_OWNER
      Owner of the 1st detail object
   DETAILOBJ1_RELATION
      Name of the 1st detail object
   DETAILOBJ1_COLUMN
      Name of the 1st detail object column
   OPERATOR
      Name of the join operator. Currently only = is defined
   DETAILOBJ2_OWNER
      Owner of the 2nd detail object
   DETAILOBJ2_RELATION
      Name of the 2nd detail object
   DETAILOBJ2_COLUMN
      Name of the 2nd detail object column

Related:


Simon Sheppard
 SS64.com