How do you analyze table partition using oracle provided package?
- 1 Answers
- 595 Views
- I also Faced
- E-Mail Answers
Answer Posted / Chandra Kumar Misra
To analyze table partitions in Oracle Database, one can use the DBMS_STATS package to gather statistics on each partition. You can execute the following command: DBMS_STATS.GATHER_TABLE_STATS(ownname => '<owner>', tabname => '<table_name>', estimate_percentage => '<estimate percentage>', method_opt => 'FOR ALL PARTITIONS');
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
