/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 vote391 views1 answer
Mariadb cast to int
SQL
0 vote363 views1 answer
Typeorm raw sql
SQL
0 vote338 views1 answer
How to print records of employees hired in particular month in oracle
SQL
5 votes386 views4 answers
Mysql update column with value from another table
SQL
5 votes339 views3 answers
String concatenation sql server
SQL
0 vote337 views1 answer
Sql server split string and insert into table select
SQL
0 vote356 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote340 views1 answer
Power query case when
SQL
0 vote364 views1 answer
Openquery join two tables
SQL
9 votes355 views1 answer
Mysql check date range
SQL