/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 vote283 views1 answer
Count database access django
SQL
0 vote274 views1 answer
Postgresql interview questions
SQL
0 vote251 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
16 votes291 views3 answers
Update table from another table
SQL
0 vote275 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote298 views1 answer
Check command
SQL
0 vote292 views1 answer
Mysql select random rows large table
SQL
0 vote309 views10 answers
Sql statement checker corrector
SQL
1 vote254 views1 answer
Postgres get timestamp
SQL
10 votes259 views3 answers
Insert into auto increment mysql
SQL