VIEW: SYS.DBA_TAB_PENDING_STATS

Source

View Text - Preformatted

select u.name, o.name, null, null, h.rowcnt, h.blkcnt, h.avgrln,
         h.samplesize, h.analyzetime
  from   sys.user$ u, sys.obj$ o, sys.wri$_optstat_tab_history h
  where  h.obj# = o.obj# and o.type# = 2 and o.owner# = u.user#
    and  h.savtime > systimestamp
  union all
  -- partitions
  select u.name, o.name, o.subname, null, h.rowcnt, h.blkcnt,
         h.avgrln, h.samplesize, h.analyzetime
  from   sys.user$ u, sys.obj$ o, sys.wri$_optstat_tab_history h
  where  h.obj# = o.obj# and o.type# = 19 and o.owner# = u.user#
    and  h.savtime > systimestamp
  union all
  -- sub partitions
  select u.name, osp.name, ocp.subname, osp.subname, h.rowcnt,
         h.blkcnt, h.avgrln, h.samplesize, h.analyzetime
  from  sys.user$ u,  sys.obj$ osp, 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# = u.user#
    and h.savtime > systimestamp

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, NULL
, NULL
, H.ROWCNT
, H.BLKCNT
, H.AVGRLN
, H.SAMPLESIZE
, H.ANALYZETIME
FROM SYS.USER$ U
, SYS.OBJ$ O
, SYS.WRI$_OPTSTAT_TAB_HISTORY H
WHERE H.OBJ# = O.OBJ#
AND O.TYPE# = 2
AND O.OWNER# = U.USER#
AND H.SAVTIME > SYSTIMESTAMP UNION ALL -- PARTITIONS SELECT U.NAME
, O.NAME
, O.SUBNAME
, NULL
, H.ROWCNT
, H.BLKCNT
, H.AVGRLN
, H.SAMPLESIZE
, H.ANALYZETIME
FROM SYS.USER$ U
, SYS.OBJ$ O
, SYS.WRI$_OPTSTAT_TAB_HISTORY H
WHERE H.OBJ# = O.OBJ#
AND O.TYPE# = 19
AND O.OWNER# = U.USER#
AND H.SAVTIME > SYSTIMESTAMP UNION ALL -- SUB PARTITIONS SELECT U.NAME
, OSP.NAME
, OCP.SUBNAME
, OSP.SUBNAME
, H.ROWCNT
, H.BLKCNT
, H.AVGRLN
, H.SAMPLESIZE
, H.ANALYZETIME
FROM SYS.USER$ U
, SYS.OBJ$ OSP
, 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# = U.USER#
AND H.SAVTIME > SYSTIMESTAMP