GV$AW_AGGREGATE_OP definition in Oracle Database 11.2
GV$AW_AGGREGATE_OP

select
  inst_id,                                 -- INST_ID NUMBER
  name_xsagopft as name,                   -- NAME VARCHAR2(14)
  desc_xsagopft as longname,               -- LONGNAME VARCHAR2(30)
  case                                     -- DEFAULT_WEIGHT NUMBER 
     when weight_xsagopft >= 0 
     then weight_xsagopft 
     else null end as default_weight 
from
  x$xsagop
where
  not bitand(flags_xsagopft, 32) = 0

home |  up