Search notes:

Oracle Event 10513

The 10053 trace documents the considarations made and decisions taken by the optimizer.
Compare with dbms_sqldiag.dump_trace which also produces a 10053 trace, but does not execute the SQL statement.

Tracing a given SQL statement

The following command traces a given SQL statement (identified by an SQL-id such as 68maq1b045ms3): 
alter session set events 'trace[rdbms.SQL_Optimizer.*][sql:68maq1b045ms3]

Turn tracing off

alter session set events 'trace[rdbms.SQL_Optimizer.*] off;

See also

MOS Note 225598.1

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...', 1758199094, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/adminstration/init-parameters/event/list/10053/index(49): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51