how to check last gather stats on table in oracle
Solutions on MaxInterview for how to check last gather stats on table in oracle by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "how to check last gather stats on table in oracle"
Giulia
16 Mar 2016
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 gather table statisticsoracle get current schemaoracle session statisticsoracle tablespace usageoracle list dates without weekendsoracle last day of monthoracle last connexionoracle db get table sizeshow to know the character set of an oracle databeshow to check rollback status in oraclehow to check table lock in oracle sql developeralter table add check constraint oracleoracle user quota on tablespaceoracle current session detailsquery to find table size in oracle 12csql oracle take only last resultsoracle current sequence valueoracle check table lockoracle get table keyoracle show grants on tableoracle table sizeoracle rolling backidentify primary key in oracle tableoracle current dateoracle user last connection dateoracle calculated column your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful