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 vote280 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote276 views1 answer
Monthly Birthday SQL Query
SQL
1 vote268 views1 answer
Oracle case
SQL
0 vote240 views1 answer
Check sql query executed wp
SQL
0 vote279 views1 answer
How to move a column to different spot mysql
SQL
0 vote218 views1 answer
<script>alert
SQL
0 vote269 views1 answer
Update using case in mysql
SQL
1 vote271 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
4 votes323 views4 answers
Mysql get date from datetime
SQL
0 vote279 views1 answer
Open postgresql.conf in centos
SQL