/SQL/How to check last gather stats on table in oracle

How to check last gather stats on table in oracle

SELECT ST.TABLE_NAME, ST.PARTITION_NAME, HIGH_VALUE, ST.NUM_ROWS, 
	   ST.BLOCKS, ST.LAST_ANALYZED
FROM DBA_TAB_STATISTICS ST
LEFT JOIN DBA_TAB_PARTITIONS PAR
ON PAR.TABLE_NAME = ST.TABLE_NAME AND PAR.PARTITION_NAME = ST.PARTITION_NAME
WHERE ST.OWNER = 'MY_OWNER'
  AND ST.TABLE_NAME = 'MY_TABLE'
ORDER BY PARTITION_NAME;

Similar codes

0 vote162 views1 answer
Postgresql get current user name
SQL
1 vote167 views1 answer
Add time to date sql
SQL
3 votes179 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
12 votes179 views2 answers
Insert multiple rows from another table sql
SQL
0 vote167 views1 answer
Get duplicate entry sql
SQL
1 vote162 views1 answer
Substr sql last character
SQL
1 vote175 views1 answer
How to put value in variable mysql
SQL
0 vote133 views1 answer
Mysql convert column to uppercase
SQL
0 vote240 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote185 views2 answers
How to take recent row without limit in mysql
SQL