select num_rows, last_analyzed from user_tab_statistics where table_name = 'TEST_OUT' ;
  NUM_ROWS LAST_ANALYZED
---------- -------------
     40008 30-МАЙ-17    
1 row selected.

select num_rows, last_analyzed from user_tables where table_name = 'TEST_OUT' ;
  NUM_ROWS LAST_ANALYZED
---------- -------------
     40008 30-МАЙ-17

select /*+ gather_plan_statistics */ t.*
from t join test_out o on o.id = t.object_id;

SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR( format =>'ALLSTATS LAST'));

SQL_ID  9rsj7ng96tyzs, child number 0
-------------------------------------
select /*+ gather_plan_statistics */ t.* from t join test_out o on o.id 
= t.object_id
 
Plan hash value: 430525702
 
------------------------------------------------------------------------------------------------------------
| Id  | Operation                    | Name     | Starts | E-Rows | A-Rows |   A-Time   | Buffers | Reads  |
------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT             |          |      1 |        |  32272 |00:00:00.14 |    2394 |    179 |
|   1 |  NESTED LOOPS                |          |      1 |      1 |  32272 |00:00:00.14 |    2394 |    179 |
|   2 |   NESTED LOOPS               |          |      1 |     11 |  32272 |00:00:00.04 |    1280 |     22 |
|   3 |    TABLE ACCESS STORAGE FULL | TEST_OUT |      1 |     11 |  39994 |00:00:00.01 |     100 |     22 |
|*  4 |    INDEX RANGE SCAN          | T_IND    |  39994 |      1 |  32272 |00:00:00.03 |    1180 |      0 |
|   5 |   TABLE ACCESS BY INDEX ROWID| T        |  32272 |      1 |  32272 |00:00:00.07 |    1114 |    157 |
------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   4 - access("O"."ID"="T"."OBJECT_ID")
 
Note
-----
   - this is an adaptive plan
 

select num_rows, to_char(last_analyzed, 'yyyy-mm-dd hh24:mi:ss') as lasst_analyzed from user_tab_statistics where table_name = 'TEST_OUT' ;

  NUM_ROWS LAST_ANALYZED               
---------- ----------------------------
     39994 2017-05-30 12:42:06         
1 row selected.


column sql_text format a50
column last_active_time format a20
column first_load_time format a20
column last_load_time format a20
select sql_text, last_active_time,  first_load_time, last_load_time
from v$sql where sql_id = '9rsj7ng96tyzs' ;


SQL_TEXT                                           LAST_ACTIVE_TIME     FIRST_LOAD_TIME      LAST_LOAD_TIME      
-------------------------------------------------- -------------------- -------------------- --------------------
select /*+ gather_plan_statistics */ t.* from t jo                      2017-05-29/13:04:37  2017-05-30/07:51:26 
in test_out o on o.id = t.object_id                                                                              
                                                                                                                                                                
1 row selected.