MDSYS.SDO_ROUTER_PARTITION dependencies on DBMS_STATS

Line 1150: stmt VARCHAR2(256):= 'EXECUTE DBMS_STATS.GATHER_TABLE_STATS(:schema_name, :table_name, NULL, DBMS_STATS.AUTO_SAMPLE_SIZE)';

1146: ---
1147: ---
1148: PROCEDURE gather_table_stats(table_name IN VARCHAR2)
1149: IS
1150: stmt VARCHAR2(256):= 'EXECUTE DBMS_STATS.GATHER_TABLE_STATS(:schema_name, :table_name, NULL, DBMS_STATS.AUTO_SAMPLE_SIZE)';
1151: BEGIN
1152: IF (table_exists(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(table_name)) = 'FALSE') THEN
1153: log_message('ERROR: ' || table_name || ' not found for gather table statistics');
1154: RETURN ;

Line 1163: DBMS_STATS.GATHER_TABLE_STATS(

1159: EXECUTE IMMEDIATE stmt into schema_name;
1160: END IF;
1161:
1162: -- Gather table and index stats for the specified table
1163: DBMS_STATS.GATHER_TABLE_STATS(
1164: ownname => schema_name,
1165: tabname => table_name,
1166: estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
1167: degree => DBMS_STATS.AUTO_DEGREE);

Line 1166: estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,

1162: -- Gather table and index stats for the specified table
1163: DBMS_STATS.GATHER_TABLE_STATS(
1164: ownname => schema_name,
1165: tabname => table_name,
1166: estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
1167: degree => DBMS_STATS.AUTO_DEGREE);
1168:
1169: END gather_table_stats;
1170:

Line 1167: degree => DBMS_STATS.AUTO_DEGREE);

1163: DBMS_STATS.GATHER_TABLE_STATS(
1164: ownname => schema_name,
1165: tabname => table_name,
1166: estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
1167: degree => DBMS_STATS.AUTO_DEGREE);
1168:
1169: END gather_table_stats;
1170:
1171: ---