Oracle table statistics

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 vote245 views1 answer
Select year from dual oracle
SQL
0 vote201 views1 answer
Implicit inner join table alias with id values
SQL
0 vote201 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote216 views1 answer
Sql statement show all emails with dome
SQL
0 vote196 views1 answer
Concat column value of same user in mysql
SQL
0 vote203 views1 answer
How to query all tables mysql at the same time
SQL
3 votes235 views2 answers
@sqlresultsetmapping
SQL
2 votes211 views1 answer
How to get non distinct values in sql
SQL
0 vote206 views1 answer
Linked server delete openquery
SQL
0 vote201 views3 answers
Sql count condition
SQL