Search notes:

Oracle: DBA_SQL_PLAN_DIRECTIVES

select
  directive_id,
  type,
  enabled,
  auto_drop,
  reason,
  to_char(created      , 'dd.mm.yy hh24:mi:ss') created,
  to_char(last_modified, 'dd.mm.yy hh24:mi:ss') last_modified,
  to_char(last_used    , 'dd.mm.yy hh24:mi:ss') last_used
--notes
from
  dba_sql_plan_directives
order by
  created desc;

Github repository Oracle-Patterns, path: /Installed/data-dictionary/sql/plan/directives/show.sql

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:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758199566, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/data-dictionary/sql/plan/directives/index(54): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Oracle: DBA_SQL_PLAN_DIRECTIVES

See also