oracle calculate statistics on partition
Solutions on MaxInterview for oracle calculate statistics on partition by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle calculate statistics on partition"
Manuel
18 Mar 2018
1ANALYZE TABLE SCHEMA.MY_TABLE PARTITION (PARTITION_NAME) COMPUTE STATISTICS;
2
3exec DBMS_STATS.GATHER_TABLE_STATS('MY_USER', 'MY_TABLE', ESTIMATE_PERCENT=>50,
4 GRANULARITY=>'PARTITION', PARTNAME=>'My_PARTITION_NAME', DEGREE => 8);similar questions
oracle swap partitionpartitioning in oracle baseoracle truncate partitionoracle table statisticsoracle table sizeoracle index size calculationoracle calculated columnoracle get partition name by high valueoracle select partitionoracle user quota on tablespaceoracle list partitionshow to see all table partition in oraclehow to check last gather stats on table in oracleoracle session statisticsoracle exchange partitionoracle run duration averageoracle number to percentageoracle table statistics last analyzedoracle index partitionoracle job average durationprocedure excute monthly oracleoracle percentageoracle duration between timestampsoracle gather table statisticsoracle drop partitionquery to find table size in oracle 12coracle tablespace sizeoracle list partitioned tables 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