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

1 vote168 views1 answer
Mysql return text after a final full stop
SQL
6 votes172 views2 answers
Oracle compile trigger
SQL
0 vote141 views1 answer
How to to get current date in sql
SQL
0 vote140 views4 answers
User defined function sql
SQL
0 vote133 views1 answer
Sql server split string and insert into table select
SQL
1 vote164 views3 answers
Postgresql get difference between two dates
SQL
7 votes141 views3 answers
Sql fill table with info from anothe rtable
SQL
19 votes136 views2 answers
Mysql add column after another
SQL
41 votes213 views6 answers
Alter table add column in SQL Server
SQL
0 vote148 views1 answer
How to display value of variable in mysql
SQL