Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250802180619\orcl_j000_19812_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250802180619\orcl_j000_19812_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:35812M/63366M, Ph+PgF:41472M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 19812, image: ORACLE.EXE (J000) *** 2025-08-02 18:06:19.296 *** SESSION ID:(193.12139) 2025-08-02 18:06:19.296 *** 2025-08-02 18:06:19.296 Process diagnostic dump for ORACLE.EXE (J000), OS id=19812, pid: 24, proc_ser: 9, sid: 193, sess_ser: 12139 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 19812 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12853, hash value=3328934554 Current Wait Stack: Not in wait; last wait ended 2.697703 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 2.697728 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.000169 sec, exc=0.000169 sec, total=0.000169 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.055251 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.000007 sec, exc=0.000007 sec, total=0.000007 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.045177 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.000180 sec, exc=0.000180 sec, total=0.000180 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.716557 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.024947 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.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.012604 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.049036 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.009282 sec, exc=0.009282 sec, total=0.009282 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007750 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.000118 sec, exc=0.000118 sec, total=0.000118 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.260880 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.007895 sec, exc=0.007895 sec, total=0.007895 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000162 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.000115 sec, exc=0.000115 sec, total=0.000115 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007850 sec of elapsed time Sampled Session History of session 193 serial 12139 --------------------------------------------------- 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 --------------------------------------------------- [5 samples, 18:06:15 - 18:06:19] not in wait at each sample [1 sample, 18:06:14] idle wait at each sample [session created at: 18:06:14] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-02 18:06:19.296 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 19812, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-02 18:04:36.649924 :BA6D6BBE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.650025 :BA6D6BBF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.650053 :BA6D6BC0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.650157 :BA6D6BC1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.650185 :BA6D6BC2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.650229 :BA6D6BC3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.650484 :BA6D6BC4: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 18:04:36.650518 :BA6D6BC7:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.656885 :BA6D6BCD: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 18:04:36.656947 :BA6D6BD0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-02 18:04:36.656977 :BA6D6BD1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-02 18:04:36.664828 :BA6D6BD7: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 18:04:36.664892 :BA6D6BDA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-02 18:04:36.664925 :BA6D6BDB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-02 18:04:36.666717 :BA6D6BE1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.666762 :BA6D6BE2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.669974 :BA6D6BE3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.670255 :BA6D6BE4: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 18:04:36.670306 :BA6D6BE7:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.675100 :BA6D6BED: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 18:04:36.675168 :BA6D6BF0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-02 18:04:36.675199 :BA6D6BF1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-02 18:04:36.677024 :BA6D6BF7:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.677071 :BA6D6BF8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.677353 :BA6D6BF9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.677387 :BA6D6BFA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.677605 :BA6D6BFB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.677637 :BA6D6BFC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.677724 :BA6D6BFD:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.677943 :BA6D6BFE: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 18:04:36.677978 :BA6D6C01:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.686022 :BA6D6C07: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 18:04:36.686083 :BA6D6C0A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-02 18:04:36.686114 :BA6D6C0B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-02 18:04:36.686426 :BA6D6C11:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-08-02 18:04:36.686756 :BA6D6C12:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-08-02 18:04:36.686878 :BA6D6C13:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.687172 :BA6D6C14: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 18:04:36.687199 :BA6D6C17:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.688789 :BA6D6C1D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:04:36.689528 :BA6D6C1E: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 18:04:36.689557 :BA6D6C21:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:04:36.690489 :BA6D6C27: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 18:05:06.781150 :BA6D75AD:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 18:05:09.662494 :BA6D769A:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 18:05:09.650 2025-08-02 18:05:09.662496 :BA6D769B:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16392 pso_num=24 pso_serial#=255 2025-08-02 18:05:09.662634 :BA6D769C:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=16392 (legacy spawn) 2025-08-02 18:05:09.669058 :BA6D769D: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 18:05:09.669237 :BA6D76A2: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 18:05:09.670062 :BA6D76A7:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 18:05:10.492456 :BA6D76D1:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 18:05:10.478 2025-08-02 18:05:10.492458 :BA6D76D2:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=7280 pso_num=24 pso_serial#=1 2025-08-02 18:05:10.492591 :BA6D76D3:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=7280 (legacy spawn) 2025-08-02 18:05:10.499062 :BA6D76D4: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 18:05:10.499236 :BA6D76DD: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 18:05:10.500088 :BA6D76DE:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 18:05:10.508800 :BA6D76E1:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 18:05:10.494 2025-08-02 18:05:10.508802 :BA6D76E2:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19676 pso_num=24 pso_serial#=2 2025-08-02 18:05:10.508949 :BA6D76E3:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=19676 (legacy spawn) 2025-08-02 18:05:10.515393 :BA6D76E4: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 18:05:10.515556 :BA6D76ED: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 18:05:10.516385 :BA6D76EE:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 18:05:13.709196 :BA6D77DF:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 18:05:13.696 2025-08-02 18:05:13.709198 :BA6D77E0:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20056 pso_num=24 pso_serial#=3 2025-08-02 18:05:13.709336 :BA6D77E1:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=20056 (legacy spawn) 2025-08-02 18:05:13.715921 :BA6D77E2: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 18:05:13.716089 :BA6D77E7: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 18:05:13.716886 :BA6D77EC:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 18:05:13.725546 :BA6D77EF:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 18:05:13.711 2025-08-02 18:05:13.725548 :BA6D77F0:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20052 pso_num=24 pso_serial#=4 2025-08-02 18:05:13.725685 :BA6D77F1:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=20052 (legacy spawn) 2025-08-02 18:05:13.732199 :BA6D77F2: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 18:05:13.732368 :BA6D77FB: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 18:05:13.733196 :BA6D77FC:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 18:05:15.910096 :BA6D78BF:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 18:05:15.899 2025-08-02 18:05:15.910098 :BA6D78C0:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19648 pso_num=24 pso_serial#=5 2025-08-02 18:05:15.910237 :BA6D78C1:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=19648 (legacy spawn) 2025-08-02 18:05:15.916696 :BA6D78C2: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 18:05:16.023972 :BA6D78EC: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 18:05:16.085072 :BA6D78EF: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 18:05:16.086014 :BA6D7900:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 18:05:36.661460 :BA6D8233:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 18:05:36.655 2025-08-02 18:05:36.661461 :BA6D8234:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18512 pso_num=24 pso_serial#=6 2025-08-02 18:05:36.661605 :BA6D8235:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=18512 osp_idx=22 osp_ver=657661 osp_pg=0 (spawn #448604) 2025-08-02 18:05:36.661606 :BA6D8236: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 18:05:36.661607 :BA6D8237:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=68 time=2838605970 2025-08-02 18:05:36.661607 :BA6D8238:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-02 18:05:36.661607 :BA6D8239:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-02 18:05:36.661608 :BA6D823A:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-02 18:05:36.661608 :BA6D823B:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-02 18:05:36.661609 :BA6D823C:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-02 18:05:36.662098 :BA6D823D: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 18:05:36.662753 :BA6D8252: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 18:05:36.670323 :BA6D826E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:05:36.670732 :BA6D826F: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 18:05:36.670765 :BA6D8272:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:05:36.671695 :BA6D8278: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 18:05:36.671823 :BA6D8281: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 18:06:06.776740 :BA6D9326:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 18:06:11.779543 :BA6D94CC:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 18:06:11.771 2025-08-02 18:06:11.779545 :BA6D94CD:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20208 pso_num=24 pso_serial#=7 2025-08-02 18:06:11.779735 :BA6D94CE:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=20208 (legacy spawn) 2025-08-02 18:06:11.786137 :BA6D94CF: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 18:06:11.786308 :BA6D94D5: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 18:06:11.787201 :BA6D94D9:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 18:06:14.708355 :BA6D95C0:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 18:06:14.703 2025-08-02 18:06:14.708357 :BA6D95C1:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=14012 pso_num=24 pso_serial#=8 2025-08-02 18:06:14.708522 :BA6D95C2:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=14012 osp_idx=22 osp_ver=657663 osp_pg=0 (spawn #448606) 2025-08-02 18:06:14.708523 :BA6D95C3:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-02 18:06:14.708524 :BA6D95C4:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=69 time=2838644017 2025-08-02 18:06:14.708524 :BA6D95C5:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-02 18:06:14.708524 :BA6D95C6:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-02 18:06:14.708524 :BA6D95C7:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-02 18:06:14.708525 :BA6D95C8:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-02 18:06:14.708525 :BA6D95C9:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-02 18:06:14.709041 :BA6D95CA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-02 18:06:14.709087 :BA6D95D0:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=18 loc='ksv2.h LINE:1639 ID:ksvpst: run' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-02 18:06:14.713254 :BA6D95E2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-02 18:06:14.713302 :BA6D95E3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-02 18:06:14.713572 :BA6D95E4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-02 18:06:14.713589 :BA6D95E5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-02 18:06:14.713811 :BA6D95E6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-02 18:06:14.713825 :BA6D95E7:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-02 18:06:14.714039 :BA6D95E8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-02 18:06:14.714052 :BA6D95E9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-02 18:06:14.714258 :BA6D95EA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-02 18:06:14.714271 :BA6D95EB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-02 18:06:14.714487 :BA6D95EC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-02 18:06:14.714504 :BA6D95ED:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-02 18:06:14.716997 :BA6D961B:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-02 18:06:14.805261 :BA6D9705:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-02 18:06:14.797 2025-08-02 18:06:14.805264 :BA6D9706:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19812 pso_num=24 pso_serial#=9 2025-08-02 18:06:14.805714 :BA6D9707:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19812 osp_idx=22 osp_ver=657664 osp_pg=0 (spawn #448608) 2025-08-02 18:06:14.805715 :BA6D9708: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 18:06:14.805716 :BA6D9709:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=70 time=2838644111 2025-08-02 18:06:14.805717 :BA6D970A:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-02 18:06:14.805717 :BA6D970B:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-02 18:06:14.805719 :BA6D970C:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-02 18:06:14.805719 :BA6D970D:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-02 18:06:14.805721 :BA6D970E:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-02 18:06:14.806875 :BA6D970F: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 18:06:14.812023 :BA6D972E: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 18:06:14.812086 :BA6D9731:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:jslv.c:9203 2025-08-02 18:06:14.829042 :BA6D9747: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 18:06:14.829233 :BA6D974F: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 18:06:14.829398 :BA6D9757: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 18:06:14.829549 :BA6D975F: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 18:06:14.829703 :BA6D9767: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 18:06:14.829881 :BA6D976F: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 18:06:14.830086 :BA6D9777: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 18:06:14.830230 :BA6D977F: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 18:06:14.830552 :BA6D9787: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 18:06:14.830803 :BA6D978F: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 18:06:14.848853 :BA6D9797: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 18:06:16.523470 :BA6D98ED: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 18:06:16.547459 :BA6D9938: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 18:06:16.549750 :BA6D9940:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-02 18:06:16.549984 :BA6D9941:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-02 18:06:16.550978 :BA6D9942: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 18:06:16.551123 :BA6D9945: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 18:06:16.552191 :BA6D9957: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 18:06:16.553995 :BA6D995F: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 18:06:16.554321 :BA6D9967: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 18:06:16.603678*: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 18:06:16.603678*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-08-02 18:06:16.603678*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-08-02 18:06:16.645026*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-08-02 18:06:16.645026*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-08-02 18:06:16.645026*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-08-02 18:06:16.645026*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-08-02 18:06:16.714008 :BA6D996F: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 18:06:18.649006 :BA6D9A48: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 18:06:18.649020 :BA6D9A49:db_trace:ktur.c@3079:ktuabt(): [10444:24:193] ABORT TRANSACTION - xid: 0x000a.01c.00175eac ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 24 (osid: 19812, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de