Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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;
Comment

PREVIOUS NEXT
Code Example
Sql :: get current month mysql 
Sql :: mysql timestamp in laravel migration 
Sql :: how to run mysql in git bash 
Sql :: Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details. 
Sql :: tsql update datetime 
Sql :: postgresql search all tables for column name 
Sql :: start mysql server mac 
Sql :: cast to date bigquery 
Sql :: sql select table header 
Sql :: add super privilege mysql 
Sql :: tsql create unique index composite 
Sql :: how to get current mysql version 
Sql :: import dump mysql 
Sql :: connect python to mysql 
Sql :: get table column names sql ssms 
Sql :: oracle next run dates 
Sql :: mssql reset auto increment 
Sql :: mysql id reset 
Sql :: mysql show foreign keys 
Sql :: yii2 mysql ping 
Sql :: moodle query item quiz 
Sql :: oracle get trigger ddl 
Sql :: insert postgres 
Sql :: get a list of table names and field names from SQL 
Sql :: oracle db create new schema 
Sql :: sqlfiddle example tables 
Sql :: convert series number to date in sql 
Sql :: mysql find and replace 
Sql :: drop table in mysql 
Sql :: create row number in sql 
ADD CONTENT
Topic
Content
Source link
Name
9+8 =