VIEW: SYS.USER_TAB_PENDING_STATS

Source

View Text - Preformatted

select o.name, null, null, h.rowcnt, h.blkcnt, h.avgrln,
         h.samplesize, h.analyzetime
  from   sys.obj$ o, sys.wri$_optstat_tab_history h
  where  h.obj# = o.obj# and o.type# = 2
         and o.owner# = userenv('SCHEMAID')
         and h.savtime > systimestamp
  union all
  -- partitions
  select o.name, o.subname, null, h.rowcnt, h.blkcnt,
         h.avgrln, h.samplesize, h.analyzetime
  from   sys.obj$ o, sys.wri$_optstat_tab_history h
  where  h.obj# = o.obj# and o.type# = 19
         and o.owner# = userenv('SCHEMAID')
         and h.savtime > systimestamp
  union all
  -- sub partitions
  select osp.name, ocp.subname, osp.subname, h.rowcnt,
         h.blkcnt, h.avgrln, h.samplesize, h.analyzetime
  from  sys.obj$ osp, sys.obj$ ocp,  sys.tabsubpart$ tsp,
        sys.wri$_optstat_tab_history h
  where h.obj# = osp.obj# and osp.type# = 34 and osp.obj# = tsp.obj#
        and tsp.pobj# = ocp.obj#
        and osp.owner# = userenv('SCHEMAID')
        and h.savtime > systimestamp

View Text - HTML Formatted

SELECT O.NAME
, NULL
, NULL
, H.ROWCNT
, H.BLKCNT
, H.AVGRLN
, H.SAMPLESIZE
, H.ANALYZETIME
FROM SYS.OBJ$ O
, SYS.WRI$_OPTSTAT_TAB_HISTORY H
WHERE H.OBJ# = O.OBJ#
AND O.TYPE# = 2
AND O.OWNER# = USERENV('SCHEMAID')
AND H.SAVTIME > SYSTIMESTAMP UNION ALL -- PARTITIONS SELECT O.NAME
, O.SUBNAME
, NULL
, H.ROWCNT
, H.BLKCNT
, H.AVGRLN
, H.SAMPLESIZE
, H.ANALYZETIME
FROM SYS.OBJ$ O
, SYS.WRI$_OPTSTAT_TAB_HISTORY H
WHERE H.OBJ# = O.OBJ#
AND O.TYPE# = 19
AND O.OWNER# = USERENV('SCHEMAID')
AND H.SAVTIME > SYSTIMESTAMP UNION ALL -- SUB PARTITIONS SELECT OSP.NAME
, OCP.SUBNAME
, OSP.SUBNAME
, H.ROWCNT
, H.BLKCNT
, H.AVGRLN
, H.SAMPLESIZE
, H.ANALYZETIME
FROM SYS.OBJ$ OSP
, SYS.OBJ$ OCP
, SYS.TABSUBPART$ TSP
, SYS.WRI$_OPTSTAT_TAB_HISTORY H
WHERE H.OBJ# = OSP.OBJ#
AND OSP.TYPE# = 34
AND OSP.OBJ# = TSP.OBJ#
AND TSP.POBJ# = OCP.OBJ#
AND OSP.OWNER# = USERENV('SCHEMAID')
AND H.SAVTIME > SYSTIMESTAMP