Search notes:

Oracle: DBA_EXPRESSION_STATISTICS

create table tq84_exp_stat (
   id integer,
   txt varchar2(128)
);

insert into tq84_exp_stat select object_id, object_name from dba_objects;

select
   id,
   txt,
   regexp_replace(txt, '[abc]', '#') no_abc
from
   tq84_exp_stat;
   
begin
   dbms_stats.flush_database_monitoring_info;
end;
/

select
-- table_name,
   created, last_modified,
   expression_text,
   fixed_cost,
   evaluation_count,
   dynamic_cost,
   snapshot,
   expression_id
from
   user_expression_statistics u
where
   u.table_name = 'TQ84_EXP_STAT'
order by
   u.created desc;

See also

EXP… base tables
Data dictionary views related to domains.

Index