Stats

--- STALE STATS FOR TABLE 
select owner,table_name,STALE_STATS from dba_tab_statistics where owner='&SCHEMA_NAME' and table_name='&TABLE_NAME'; 

-- FOR INDEX 
select owner,INDEX_NAME,TABLE_NAME from DBA_IND_STATISTICS where owner='&SCHEMA_NAME' and index_name='&INDEX_NAME';

-- For getting history of TABLE statistics 

 
select owner,TABLE_NAME,STATS_UPDATE_TIME from dba_tab_stats_history where table_name='&TABLE_NAME';


col sql_text form a80 
set lines 120 
select sql_text from gv$sqltext where hash_value= 
(select sql_hash_value from gv$session where sid=&1 and inst_id=&inst_id) 
order by piece 
/