Search notes:

Oracle: Statement ID of an execution plan

Oracle allows to specify a statement id when a plan is explained with the explain plan statement.
The purpose of this id is to identify a given execution plan in the table plan_table: the value is found in the column statement_id:
explain plan
   set statement_id = 'st1'
for
   select
      foo, bar, baz
   from
      tab;

…
select … from plan_table where statement_id = 'st1';
The statement id can also be passed as an argument to dbms_xplan.display.
select * from dbms_xplan.display(statement_id => 'st1'));

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: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...', 1737543317, '3.137.187.81', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/statement/verbs/explain/statement-id(48): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78