oracle table statistics last analyzed

Solutions on MaxInterview for oracle table statistics last analyzed by the best coders in the world

Search
showing results for - "oracle table statistics last analyzed"
Stefano
01 Jan 2017
1SELECT ST.TABLE_NAME, ST.PARTITION_NAME, HIGH_VALUE, ST.NUM_ROWS, 
2	   ST.BLOCKS, ST.LAST_ANALYZED
3FROM DBA_TAB_STATISTICS ST
4LEFT JOIN DBA_TAB_PARTITIONS PAR
5ON PAR.TABLE_NAME = ST.TABLE_NAME AND PAR.PARTITION_NAME = ST.PARTITION_NAME
6WHERE ST.OWNER = 'MY_OWNER'
7  AND ST.TABLE_NAME = 'MY_TABLE'
8ORDER BY PARTITION_NAME;
similar questions
oracle session statisticsoracle sequence last numberoracle tablespace datafile max sizeoracle table privilegesquery to find table size in oracle 12coracle rolling back transactionsoracle gather table statisticsoracle current sequence valueoracle tablespace usageoracle query to see what scema i am working intablespace oracleoracle table constraintsoracle show grants on tableoracle rolling backoracle last connexionhow to know the character set of an oracle databesoracle tablespace sizeoracle all tablesoracle calculate statistics on partitionoracle calculated columnoracle function return tableoracle user quota on tablespaceoracle table sizeidentify primary key in oracle tableoracle size of tables in schemasize of all tables in a schema oracleoracle sql lpad
queries leading to this page
oracle table statistics last analyzedoracle what does statistics usehow to check last gather stats on table in oraclestatistics oracleoracle information table get table statisticsoracle statistics tableget the statistics of table in oraclehow to do gather stats on table in oraclehow to check table statistics in oracleoracle statisticshow to gather stats of table in oracleoracle table statisticsoracle check owner of tableoracle table statistics last analyzed