DBA Data[Home] [Help]

SYS.DBMS_FEATURE_STATS_INCREMENTAL dependencies on WRI$_OPTSTAT_SYNOPSIS_HEAD$

Line 47: FROM sys.wri$_optstat_synopsis_head$

43:
44: -- # of tables that have had stats gathered in incremental mode
45: SELECT distinct count(bo#)
46: INTO stats_gathered_im
47: FROM sys.wri$_optstat_synopsis_head$
48: WHERE analyzetime is not null;
49:
50: -- the used boolean and aux count we set to the number of execs since last
51: -- sample