oracle table statistics

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

Search
showing results for - "oracle table statistics"
Leah
05 Jul 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 table privilegesoracle tablespace usageoracle function return tableoracle table sizeoracle columns tablecreate table employees oracleoracle all tables in schemaoracle tablespace tables listoracle column names of a tableoracle dependencies tabletablespace oracleoracle list tablesoracle session statisticsview acl table oraclesize of all tables in a schema oracleoracle simple quotehow to know the character set of an oracle databesoracle get table schemashow all tables in oracleoracle tables with column nameoracle user tablesoracle gather table statisticsoracle all tablesoracle size of tables in schemaoracle show grants on tableshow tables in oracleoracle table constraints
queries leading to this page
oracle check owner of tableoracle what does statistics useoracle table statistics last analyzedoracle statisticshow to check table statistics in oracleoracle statistics tablestatistics oracleoracle table statisticsgather stats on a table in oraclehow to do gather stats on table in oraclehow to check last gather stats on table in oracleget the statistics of table in oracleoracle information table get table statisticshow to gather stats of table in oracleoracle table statistics