Horje
how to check last gather stats on table in oracle Code Example
how to check last gather stats on table in oracle 
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
mysql backup skip table Code Example mysql backup skip table Code Example
woocommerce mysql price table Code Example woocommerce mysql price table Code Example
python escape string for sql Code Example python escape string for sql Code Example
replace all numbers in mysql Code Example replace all numbers in mysql Code Example
mysql subtract month from timestamp Code Example mysql subtract month from timestamp Code Example

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



 

Horje