To collect statistics for database objects, you can use DBMS

How can we collect the statistics of different database objects?

Question Posted / Satendra Pal Singh Chauhan

1 Answers
2 Views
I also Faced
E-Mail Answers

Answer Posted / Satendra Pal Singh Chauhan

To collect statistics for database objects, you can use DBMS_STATS package. You can run DBMS_STATS.GATHER_TABLE_STATS procedure to gather statistics for a specific table or DBMS_STATS.GATHER_DATABASE_STATS procedure to gather statistics for the entire database.

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