Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250802140549\orcl_j000_20104_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250802140549\orcl_j000_20104_bucket.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Windows NT Version V6.2 CPU : 32 - type 8664, 16 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:35817M/63366M, Ph+PgF:41484M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 20104, image: ORACLE.EXE (J000) *** 2025-08-02 14:05:49.748 *** SESSION ID:(193.8779) 2025-08-02 14:05:49.748 *** 2025-08-02 14:05:49.748 Process diagnostic dump for ORACLE.EXE (J000), OS id=20104, pid: 24, proc_ser: 113, sid: 193, sess_ser: 8779 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 20104 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12851, hash value=1188715138 Current Wait Stack: Not in wait; last wait ended 2.210021 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 2.210073 sec since last wait 0: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0xc9, filetype=0x2 wait_id=40 seq_num=41 snap_id=1 wait times: snap=0.000161 sec, exc=0.000161 sec, total=0.000161 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.053412 sec of elapsed time 1: waited for 'asynch descriptor resize' outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82 wait_id=39 seq_num=40 snap_id=1 wait times: snap=0.000004 sec, exc=0.000004 sec, total=0.000004 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.038899 sec of elapsed time 2: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x3, filetype=0x2 wait_id=38 seq_num=39 snap_id=1 wait times: snap=0.000162 sec, exc=0.000162 sec, total=0.000162 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.714511 sec of elapsed time 3: waited for 'asynch descriptor resize' outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82 wait_id=37 seq_num=38 snap_id=1 wait times: snap=0.000005 sec, exc=0.000005 sec, total=0.000005 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.025194 sec of elapsed time 4: waited for 'asynch descriptor resize' outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82 wait_id=36 seq_num=37 snap_id=1 wait times: snap=0.000005 sec, exc=0.000005 sec, total=0.000005 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.012785 sec of elapsed time 5: waited for 'db file sequential read' file#=0x2, block#=0x78fa, blocks=0x1 wait_id=35 seq_num=36 snap_id=1 wait times: snap=0.000112 sec, exc=0.000112 sec, total=0.000112 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.049793 sec of elapsed time 6: waited for 'db file sequential read' file#=0x2, block#=0x1e5a, blocks=0x1 wait_id=34 seq_num=35 snap_id=1 wait times: snap=0.014071 sec, exc=0.014071 sec, total=0.014071 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007832 sec of elapsed time 7: waited for 'db file sequential read' file#=0x1, block#=0x2d00, blocks=0x1 wait_id=33 seq_num=34 snap_id=1 wait times: snap=0.000122 sec, exc=0.000122 sec, total=0.000122 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.262328 sec of elapsed time 8: waited for 'db file sequential read' file#=0x1, block#=0x130, blocks=0x1 wait_id=32 seq_num=33 snap_id=1 wait times: snap=0.006432 sec, exc=0.006432 sec, total=0.006432 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000172 sec of elapsed time 9: waited for 'db file sequential read' file#=0x1, block#=0xc8, blocks=0x1 wait_id=31 seq_num=32 snap_id=1 wait times: snap=0.000118 sec, exc=0.000118 sec, total=0.000118 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007846 sec of elapsed time Sampled Session History of session 193 serial 8779 --------------------------------------------------- The sampled session history is constructed by sampling the target session every 1 second. The sampling process captures at each sample if the session is in a non-idle wait, an idle wait, or not in a wait. If the session is in a non-idle wait then one interval is shown for all the samples the session was in the same non-idle wait. If the session is in an idle wait or not in a wait for consecutive samples then one interval is shown for all the consecutive samples. Though we display these consecutive samples in a single interval the session may NOT be continuously idle or not in a wait (the sampling process does not know). The history is displayed in reverse chronological order. sample interval: 1 sec, max history 120 sec --------------------------------------------------- [4 samples, 14:05:46 - 14:05:49] not in wait at each sample [1 sample, 14:05:45] idle wait at each sample [session created at: 14:05:45] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-02 14:05:49.748 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 20104, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-02 14:04:15.588660 :BA5A8FE0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.588696 :BA5A8FE3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.593451 :BA5A8FE9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.593512 :BA5A8FEC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-02 14:04:15.593543 :BA5A8FED:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-02 14:04:15.595395 :BA5A8FF3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.595439 :BA5A8FF4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.596350 :BA5A8FF5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.596598 :BA5A8FF6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.596649 :BA5A8FF9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.604005 :BA5A8FFF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.604067 :BA5A9002:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-02 14:04:15.604099 :BA5A9003:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-02 14:04:15.611926 :BA5A9009:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.611987 :BA5A900C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-02 14:04:15.612018 :BA5A900D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-02 14:04:15.613866 :BA5A9013:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.613915 :BA5A9014:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.613939 :BA5A9015:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.613967 :BA5A9016:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.614229 :BA5A9017:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.614259 :BA5A9018:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.614265 :BA5A9019:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.614290 :BA5A901A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.614405 :BA5A901B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.614432 :BA5A901C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.614437 :BA5A901D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.614462 :BA5A901E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.614570 :BA5A901F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.614597 :BA5A9020:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.614602 :BA5A9021:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.614628 :BA5A9022:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.614732 :BA5A9023:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.614759 :BA5A9024:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.614764 :BA5A9025:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.614791 :BA5A9026:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.614897 :BA5A9027:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.614924 :BA5A9028:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.614929 :BA5A9029:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.614954 :BA5A902A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.615056 :BA5A902B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.615082 :BA5A902C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.615117 :BA5A902D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.615357 :BA5A902E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.615390 :BA5A9031:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.627422 :BA5A9037:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.627497 :BA5A903A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-02 14:04:15.627537 :BA5A903B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-02 14:04:15.629372 :BA5A9041:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.629415 :BA5A9042:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.629863 :BA5A9043:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.630127 :BA5A9044:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.630165 :BA5A9047:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.635667 :BA5A904D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.635724 :BA5A9050:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-02 14:04:15.635754 :BA5A9051:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-02 14:04:15.636057 :BA5A9057:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-08-02 14:04:15.636389 :BA5A9058:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-08-02 14:04:15.636508 :BA5A9059:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.636735 :BA5A905A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.636760 :BA5A905D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.638400 :BA5A9063:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:04:15.638630 :BA5A9064:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.638661 :BA5A9067:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:04:15.639583 :BA5A906D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:15.639692 :BA5A9076:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-02 14:04:45.733518 :BA5A9A6B:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 14:04:46.931255 :BA5A9AB2:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 14:04:46.921 2025-08-02 14:04:46.931258 :BA5A9AB3:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19224 pso_num=24 pso_serial#=108 2025-08-02 14:04:46.931400 :BA5A9AB4:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=19224 (legacy spawn) 2025-08-02 14:04:46.938079 :BA5A9AB5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:04:46.977816 :BA5A9ABE:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-02 14:04:46.978754 :BA5A9ABF:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 14:05:13.491269 :BA5AA2E6:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 14:05:13.479 2025-08-02 14:05:13.491271 :BA5AA2E7:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=12284 pso_num=24 pso_serial#=109 2025-08-02 14:05:13.491405 :BA5AA2E8:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=12284 (legacy spawn) 2025-08-02 14:05:13.497921 :BA5AA2E9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:13.498102 :BA5AA2EE:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-02 14:05:13.498965 :BA5AA2F3:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 14:05:14.383483 :BA5AA358:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 14:05:14.369 2025-08-02 14:05:14.383485 :BA5AA359:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=7996 pso_num=24 pso_serial#=110 2025-08-02 14:05:14.383616 :BA5AA35A:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=7996 (legacy spawn) 2025-08-02 14:05:14.404657 :BA5AA35B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:14.404831 :BA5AA361:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-02 14:05:14.405652 :BA5AA365:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 14:05:14.414334 :BA5AA368:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 14:05:14.400 2025-08-02 14:05:14.414336 :BA5AA369:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=4700 pso_num=24 pso_serial#=111 2025-08-02 14:05:14.414476 :BA5AA36A:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=4700 (legacy spawn) 2025-08-02 14:05:14.421069 :BA5AA36B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:14.421241 :BA5AA374:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-02 14:05:14.422037 :BA5AA375:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 14:05:15.603877 :BA5AA6C3:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 14:05:15.598 2025-08-02 14:05:15.603879 :BA5AA6C4:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18516 pso_num=24 pso_serial#=112 2025-08-02 14:05:15.604025 :BA5AA6C5:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=18516 osp_idx=22 osp_ver=656237 osp_pg=0 (spawn #448047) 2025-08-02 14:05:15.604026 :BA5AA6C6:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-02 14:05:15.604026 :BA5AA6C7:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=67 time=2824184908 2025-08-02 14:05:15.604027 :BA5AA6C8:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-02 14:05:15.604028 :BA5AA6C9:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-02 14:05:15.604028 :BA5AA6CA:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-02 14:05:15.604028 :BA5AA6CB:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-02 14:05:15.604029 :BA5AA6CC:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-02 14:05:15.604524 :BA5AA6CD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-02 14:05:15.605167 :BA5AA6E2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:15.612716 :BA5AA6FE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:05:15.613098 :BA5AA6FF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:15.613136 :BA5AA702:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:05:15.613971 :BA5AA708:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:15.614084 :BA5AA711:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-02 14:05:45.712138 :BA5AB85E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 14:05:45.748534 :BA5AB8CF:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 14:05:45.743 2025-08-02 14:05:45.748536 :BA5AB8D0:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20104 pso_num=24 pso_serial#=113 2025-08-02 14:05:45.748678 :BA5AB8D1:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=20104 osp_idx=22 osp_ver=656238 osp_pg=0 (spawn #448051) 2025-08-02 14:05:45.748680 :BA5AB8D2:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-02 14:05:45.748680 :BA5AB8D3:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=68 time=2824215048 2025-08-02 14:05:45.748680 :BA5AB8D4:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-02 14:05:45.748681 :BA5AB8D5:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-02 14:05:45.748681 :BA5AB8D6:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-02 14:05:45.748681 :BA5AB8D7:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-02 14:05:45.748682 :BA5AB8D8:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-02 14:05:45.749181 :BA5AB8D9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.754259 :BA5AB8F8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.754309 :BA5AB8FB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:jslv.c:9203 2025-08-02 14:05:45.771805 :BA5AB93B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.772007 :BA5AB943:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.772172 :BA5AB94B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.772327 :BA5AB953:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.772484 :BA5AB95B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.772670 :BA5AB963:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.772874 :BA5AB96B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.773035 :BA5AB973:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.773182 :BA5AB97B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.773491 :BA5AB983:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.773733 :BA5AB98B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:45.790853 :BA5AB993:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:47.065542*:BA5AB9F8:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000027173AD0 estart=1754114747 eid=20971732 ctx=0x0000000777968158 cwh=0x0000000031930068 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-08-02 14:05:47.065542*:BA5AB9F9:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000027173AD0 curCtx=0x00000000319F19A8 pubTabIdxCnt=0 2025-08-02 14:05:47.065542*:BA5AB9FA:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000027173AD0 2025-08-02 14:05:47.065542*:BA5AB9FB:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000027173AD0 2025-08-02 14:05:47.065542*:BA5AB9FC:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000271FB820 estart=1754114745 eid=16777493 ctx=0x000000077B54EAC8 cwh=0x0000000024D80608 cpu=1093750 buffg=59768 interb=196608 r=24 rb=196608 w=0 wb=0 2025-08-02 14:05:47.065542*:BA5AB9FD:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000271FB820 curCtx=0x00000000319F9FF0 pubTabIdxCnt=0 2025-08-02 14:05:47.065542*:BA5AB9FE:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000271FB820 2025-08-02 14:05:47.065542*:BA5AB9FF:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000271FB820 2025-08-02 14:05:47.065542*:BA5ABA00:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000027173AD0 curCtx=0x00000000319F19A8 xsc->flg4=65792 flags=1 2025-08-02 14:05:47.065542*:BA5ABA01:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000027173AD0 2025-08-02 14:05:47.448134 :BA5ABAFB:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 9, ext 0, nex 3 2025-08-02 14:05:47.448140 :BA5ABAFC:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00800356 where: kduwh01: kdusru 2025-08-02 14:05:47.462943 :BA5ABB0E:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 9, ext 1, nex 4 2025-08-02 14:05:47.462951 :BA5ABB0F:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008127b8 where: kduwh01: kdusru 2025-08-02 14:05:47.462951*:BA5ABB19:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000271FB820 curCtx=0x00000000319F9FF0 xsc->flg4=65792 flags=2 2025-08-02 14:05:47.462951*:BA5ABB1A:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000271FB820 2025-08-02 14:05:47.468698 :BA5ABB1B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:47.488745 :BA5ABB58:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:47.490917 :BA5ABB73:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 14:05:47.491328 :BA5ABB74:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 14:05:47.492214 :BA5ABB75:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:47.492307 :BA5ABB78:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:47.493246 :BA5ABB8A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:47.494739 :BA5ABB92:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:47.495023 :BA5ABB9A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:47.534288*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-08-02 14:05:47.549928*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-08-02 14:05:47.549928*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-08-02 14:05:47.549928*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-08-02 14:05:47.549928*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-08-02 14:05:47.549928*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-08-02 14:05:47.549928*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-08-02 14:05:47.612284 :BA5ABBA2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:49.479020 :BA5ABC35:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 14:05:49.479032 :BA5ABC36:db_trace:ktur.c@3079:ktuabt(): [10444:24:193] ABORT TRANSACTION - xid: 0x000a.002.00175e22 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 24 (osid: 20104, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de