Horje
oracle table statistics last analyzed Code Example
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;



Sql

Related
add auto_increment column to existing table mysql Code Example add auto_increment column to existing table mysql Code Example
sql for date greater than Code Example sql for date greater than Code Example
SQLite order random Code Example SQLite order random Code Example
mysql server is not starting xampp Code Example mysql server is not starting xampp Code Example
query string starts with vowels Code Example query string starts with vowels Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 9



 

Horje