Search notes:

Oracle: DBA_OPTSTAT_OPERATION_TASKS

select
   ops.id, -- tsk.opid,
   ops.operation,
   tsk.target_objn     target_obj_nr,
   ops.target          target, tsk.target target_tsk,
   tsk.target_size     nof_blocks,
   tsk.estimated_cost  esitated_secs,
   tsk.batching_coeff,
   tsk.actions,
-- tsk.priority,                           -- Rank of task within same parent operation
   tsk.flags,
-- ops.start_time, ops.end_time,
   tsk.start_time, tsk.end_time,
   ops.status,
   tsk.status,
   ops.job_name,
   tsk.job_name,
   ops.session_id,
   tsk.notes,
   ops.notes
from
   dba_optstat_operations      ops                       left join
   dba_optstat_operation_tasks tsk on ops.id = tsk.opid
order by
   ops.start_time desc,
   ops.id,
   tsk.priority;

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...', 1758207713, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/data-dictionary/optstat/operation_tasks/index(61): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Oracle: DBA_OPTSTAT_OPERATION_TASKS

See also