select /* CHOOSE*/
  o.owner,o.object_name,o.object_id,o.object_type, p.exc, a.blk* 8192 / 1024 / 1024  size_mb, 
  ss.lrds, round(ss.lrds/st.st),
  pr.prds, round(pr.prds/st.st)
from dba_objects o,
  (select p.OBJECT#, sum(p.exc) exc from
    (
    select pl.OBJECT#,sum(s.EXECUTIONS) exc  from gv$sql_plan pl, gv$sql s 
      where  1 = 1 
        and pl.ADDRESS=s.ADDRESS
        and pl.HASH_VALUE=s.HASH_VALUE
        and pl.CHILD_NUMBER=s.CHILD_NUMBER
        and pl.inst_id= 1  and s.inst_id= 1 
      group by pl.OBJECT#  
/*     union all
     select pl.OBJECT#,sum(s.EXECUTIONS) exc  from gv$sql_plan pl, gv$sql s 
      where 1=1
        and pl.ADDRESS=s.ADDRESS
        and pl.HASH_VALUE=s.HASH_VALUE
        and pl.CHILD_NUMBER=s.CHILD_NUMBER
        and pl.inst_id=2 and s.inst_id=2
      group by pl.OBJECT#       */
    ) p
    group by p.OBJECT#
  ) p,
  (SELECT s.owner,s.segment_name, sum(s.blocks) blk FROM dba_segments S group by s.owner,s.segment_name) a,
  (select ss.OWNER, ss.OBJECT_NAME, sum(ss.value) lrds from v$segment_statistics ss where ss.STATISTIC#= 0  group by ss.OWNER, ss.OBJECT_NAME) ss,
  (select ss.OWNER, ss.OBJECT_NAME, sum(ss.value) prds from v$segment_statistics ss where ss.STATISTIC#= 3  group by ss.OWNER, ss.OBJECT_NAME) pr,
  (select (sysdate-startup_time) st from v$instance) st 
  
where  1 = 1 
  and o.object_id=p.object#(+)
  and o.owner=a.owner
  and o.object_name=a.segment_name
  and o.owner=ss.owner
  and o.object_name=ss.OBJECT_NAME  
  and o.owner=pr.owner
  and o.object_name=pr.OBJECT_NAME  
  and o.object_type='INDEX'
  and o.owner='ОВНЕР'
order by  6  desc  
;