Update Reorg Need for specific table (4328478)

How to update the Reorg Need value for a specific table.

Before 8.1 version, there was an option to use analysis group to collect the statistics and update the Reorg Need value for user-defined group of objects, such as by tablespace or schema or any criteria.

Starting 8.1, there is no longer an option to create the analysis group.

Workaround:

Manually run package QUEST_SPC_STAT_CALC to update the Reorg Need value (in both Space Manager 8.0 and 8.1).

Procedure ojbect_update (

     object_owner_for_upd in varchar2,

     object_nam_for_upd in varchar2,

     object_type in varchar2,

     get_dd_stats in boolean default true,

     clac_statistics in boolean default true);

For example, to update the table JOE.EMPLOYEES, the call would be as follows:

Begin

    quest_spc_stat_calc.object_update(

          'JOE',

          'EMPLOYEES',

          'TABLE');

end;

/

Note: The parameters get_dd_stats and calc_statistics will be TRUE by default. Calc_statistics has to be TRUE in order to compute Rerog Need.