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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759993744, '216.73.216.133', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/data-dictionary/expression_statistics(71): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51