with plan_objects as
     ( select --+ materialize
              p.object_owner
            , p.object_name
            , p.object_type
            , p.partition_start
            , p.partition_stop
            , p.cardinality
            , p.operation
            , p.options
            , count(*) as occurs_in_plan
       from   v$sql_plan_statistics_all p
       where  p.sql_id = :sql_id
       and    p.child_number = :sql_child_number
       and    p.plan_hash_value =
              ( select plan_hash_value from
                       ( select plan_hash_value, row_number() over (order by timestamp desc) as seq
                         from   gv$sql_plan p
                         where  p.sql_id = :sql_id
                         and    p.child_number = :sql_child_number
                         and    p.inst_id = :instance )
                where seq = 1 )
       and    p.object_type != 'VIEW'
       group by p.object_owner, p.object_name, p.object_type, p.partition_start, p.partition_stop, p.cardinality, p.operation, p.options )
   , object_stats as
     ( select ts.owner as object_owner
            , ts.table_name as object_name
            , ts.table_name as display_name
            , ts.num_rows
            , ts.blocks
            , ts.last_analyzed
            , ts.stale_stats
       from   dba_tab_statistics ts
       where  (ts.owner, ts.table_name)  in
              (select object_owner, object_name from plan_objects where object_type like 'TABLE%')
       and    ts.partition_name is null
       union
       select xs.owner
            , xs.index_name
            , '(' || xs.table_name || ') ' || index_name as display_name
            , xs.num_rows
            , xs.leaf_blocks as blocks
            , xs.last_analyzed
            , xs.stale_stats
       from   dba_ind_statistics xs
       where  (xs.owner, xs.index_name) in
              (select object_owner, object_name from plan_objects where object_type like 'INDEX%')
       and    xs.partition_name is null
     )
select --+ dynamic_sampling(8)
       object_owner
     , nvl(s.display_name,object_name) as object_name
     , o.object_type
     , o.occurs_in_plan
     , o.operation || ' ' || o.options as operation
     , o.cardinality
     , s.num_rows as "Rows (global)"
     , s.blocks
     , s.last_analyzed
     , s.stale_stats as "Stale?"
     , o.partition_start
     , o.partition_stop
from   plan_objects o
       left join object_stats s using(object_owner, object_name)
order by
      case object_owner when 'SYS' then 2 else 1 end
    , object_owner
    , case substr(object_type,1,5) when 'TABLE' then 1 when 'CLUST' then 2 when 'INDEX' then 3 else 4 end
    , object_type
    , object_name

SQL> select count(*) from t;

  COUNT(*)
----------
         0

SQL>  select table_name, num_rows, last_analyzed, stale_stats from user_tab_statistics where table_name='T';

TABLE_NAME                       NUM_ROWS LAST_ANAL STA
------------------------------ ---------- --------- ---
T                                       0 26-JAN-13 NO

SQL> select count(*) from t;

  COUNT(*)
----------
    991000

SQL>  select table_name, num_rows, last_analyzed, stale_stats from user_tab_statistics where table_name='T';

TABLE_NAME                       NUM_ROWS LAST_ANAL STA
------------------------------ ---------- --------- ---
T                                       0 26-JAN-13 NO

exec dbms_stats.flush_database_monitoring_info

SQL> select 1901000*0.1 from dual;

1901000*0.1
-----------
     190100

SQL> delete from t where rownum <= 190100;

190100 rows deleted.

SQL> commit;

Commit complete.

SQL> exec dbms_stats.flush_database_monitoring_info;

PL/SQL procedure successfully completed.

SQL> select table_name, num_rows, last_analyzed, stale_stats from user_tab_statistics where table_name='T';

TABLE_NAME                       NUM_ROWS LAST_ANAL STA
------------------------------ ---------- --------- ---
T                                 1901000 29-JAN-13 YES