32:
33: EXIT WHEN tab_list%NOTFOUND;
34:
35: IF var_partitioned='YES' THEN
36: fnd_stats.gather_table_stats(
37: v_applsys_schema,
38: var_table_name,
39: granularity => 'PARTITION');
40: ELSE
37: v_applsys_schema,
38: var_table_name,
39: granularity => 'PARTITION');
40: ELSE
41: fnd_stats.gather_table_stats(v_applsys_schema, var_table_name);
42: END IF;
43:
44: END LOOP;
45:
86: IF p_instance_id IS NULL AND
87: p_plan_id IS NULL THEN
88:
89: /* analyse all the partitions */
90: fnd_stats.gather_table_stats(
91: v_applsys_schema,
92: var_table_name,
93: granularity => 'PARTITION');
94:
108: var_partition_name,
109: var_return_status,
110: var_msg_data);
111:
112: fnd_stats.gather_table_stats(
113: v_applsys_schema,
114: var_table_name,
115: 10,
116: 4,
117: var_partition_name);
118:
119: END IF;
120: ELSE
121: fnd_stats.gather_table_stats(v_applsys_schema, var_table_name, 10, 4);
122: END IF;
123:
124: CLOSE tab_list;
125: