Wednesday, June 10, 2009

Oracle Auto execute taks (KTSJ). Step 1.

i am finding the list of Oracle 11g auto-execute tasks. The tech using for scheduling jobs for SMCO (space management coordinator ).

sqlplus /nolog
SQL>connect / as sysdba
...
SQL>oradebug setospid ...
...
SQL>oradebug call ktsj_dump_tasks
...
looking in trace file ... Not much info, but something ;)