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

-2 votes138 views2 answers
Union all in sql
SQL
0 vote88 views2 answers
Spring properties file for db
SQL
26 votes133 views2 answers
Mysql workbench download
SQL
1 vote121 views4 answers
Get week day from date in sql
SQL
0 vote185 views1 answer
How to rename a database in tsql
SQL
0 vote130 views1 answer
Grant access on table in oracle
SQL
5 votes135 views2 answers
Mysql where in array
SQL
0 vote137 views1 answer
Postgresql list extensions
SQL
4 votes116 views1 answer
Oracle session date format
SQL
0 vote136 views1 answer
Sql server on mac m1
SQL