/SQL/Oracle table statistics last analyzed

Oracle table statistics last analyzed

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 vote260 views1 answer
How to find all children of a record with only parent ID in sql
SQL
7 votes240 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote250 views1 answer
Selecting all columns from table sql database
SQL
0 vote245 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote225 views1 answer
Rabbitmq service not starting
SQL
0 vote252 views1 answer
Manage Database in MySQL
SQL
1 vote239 views1 answer
Postgresql transaction discard all
SQL
1 vote226 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote234 views1 answer
Select all same column value in sql
SQL
1 vote231 views1 answer
Psql filed name alter
SQL