BEGIN
  --SYS_P198014
  dbms_stats.gather_table_stats(ownname          => 'XXX',
                                tabname          => 'TRANSACTION',
                                partname         => 'SYS_P111111',
                                degree           => 8,
                                method_opt       => 'FOR ALL COLUMNS SIZE 1 FOR COLUMNS SIZE 254 (TR_DATE, ID_DEBIT)',
                                estimate_percent => 10);
END;

BEGIN
  dbms_stats.gather_table_stats(ownname          => 'XXX',
                                tabname          => 'BC_REALIZEDTRANSACTION',
                                partname         => 'SYS_P111111',
                                degree           => 8,
                                method_opt       => 'FOR ALL COLUMNS SIZE 1 FOR COLUMNS (TR_DATE, ID_DEBIT) SIZE 254 ',
                                estimate_percent => 2.5,
                                block_sample     => TRUE);
END;

SELECT *
  FROM DBA_PART_HISTOGRAMS ph
 WHERE table_name = 'TRANSACTION'
   AND ph.partition_name = 'SYS_P111111'
   AND column_name = 'ID_DEBIT'
   AND endpoint_value = 12223131;