question

OraLearner avatar image
OraLearner asked

How do we analyze table partition using Oracle provided package ?

how to analyze table partition using the Oracle provided package. If anyone knows what is the option to do this then please let me know. Thanks in advance.

oracletabledeveloperpartition
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Andrew Mobbs avatar image
Andrew Mobbs answered

Just specify the partname parameter to dbms_stats.gather_table_stats:

exec dbms_stats.gather_table_stats(ownname=>'<USER>',
                                   tabname=>'<TABLE>',
                                   partname=>'<PARTITION>',
                                   <etc.>
                                   )
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.