Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250531060006\orcl_j005_12592_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250531060006\orcl_j005_12592_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:37248M/63366M, Ph+PgF:44127M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 31 Windows thread id: 12592, image: ORACLE.EXE (J005) *** 2025-05-31 06:00:06.259 *** SESSION ID:(249.891) 2025-05-31 06:00:06.259 *** 2025-05-31 06:00:06.259 Process diagnostic dump for ORACLE.EXE (J005), OS id=12592, pid: 31, proc_ser: 177, sid: 249, sess_ser: 891 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 12592 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J005) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=9 seq_num=10 snap_id=1 wait times: snap=0.080113 sec, exc=0.080113 sec, total=0.080113 sec wait times: max=0.500000 sec, heur=4.186309 sec wait counts: calls=1 os=1 in_wait=1 iflags=0x5a8 Wait State: fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.000005 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=8 seq_num=9 snap_id=1 wait times: snap=0.500012 sec, exc=0.500012 sec, total=0.500012 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.500002 sec, exc=0.500002 sec, total=0.500002 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 snap_id=1 wait times: snap=0.499993 sec, exc=0.499993 sec, total=0.499993 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.500268 sec, exc=0.500268 sec, total=0.500268 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 snap_id=1 wait times: snap=0.500005 sec, exc=0.500005 sec, total=0.500005 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000005 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.499988 sec, exc=0.499988 sec, total=0.499988 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000016 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.499994 sec, exc=0.499994 sec, total=0.499994 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000013 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 snap_id=1 wait times: snap=0.499176 sec, exc=0.499176 sec, total=0.499176 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000004 sec of elapsed time 8: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.106679 sec, exc=0.106679 sec, total=0.106679 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000000 sec of elapsed time Sampled Session History of session 249 serial 891 --------------------------------------------------- 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, 06:00:02 - 06:00:06] idle wait at each sample [session created at: 06:00:02] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-05-31 06:00:06.259 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 31 (osid: 12592, J005) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-05-29 22:00:01.661801 :9DBACAB8:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-05-29 22:00:01.661801 :9DBACAB9:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=138 time=1531762422 2025-05-29 22:00:01.661801 :9DBACABA:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-05-29 22:00:01.661801 :9DBACABB:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-05-29 22:00:01.661802 :9DBACABC:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-05-29 22:00:01.661802 :9DBACABD:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-29 22:00:01.661802 :9DBACABE:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-29 22:00:01.662255 :9DBACAC7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.667173 :9DBACAEE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.667203 :9DBACAF2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:jslv.c:9203 2025-05-29 22:00:01.682956 :9DBACB87:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.683193 :9DBACB8F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.683425 :9DBACB97:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.683627 :9DBACB9F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.683833 :9DBACBA7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.684222 :9DBACBAF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.684447 :9DBACBB7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.684644 :9DBACBBF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.684968 :9DBACBC7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.685312 :9DBACBD7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.685607 :9DBACBDF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.686211 :9DBACBED:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.686351 :9DBACBF7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.686594 :9DBACC15:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.686839 :9DBACC31:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.686869 :9DBACC33:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.687053 :9DBACC46:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.687243 :9DBACC4E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.687430 :9DBACC57:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.687591 :9DBACC63:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.687621 :9DBACC65:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.687802 :9DBACC77:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.687984 :9DBACC7F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.688169 :9DBACC87:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.688354 :9DBACC8F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.688535 :9DBACC97:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.688717 :9DBACC9F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.688901 :9DBACCA7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.689110 :9DBACCAF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.689293 :9DBACCB7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.689482 :9DBACCBF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.689665 :9DBACCC7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.689850 :9DBACCCF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.691951 :9DBACCDC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.692154 :9DBACCE8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-05-29 22:00:01.718202 :9DBACE5A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:03.529703*:9DBAD27A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000322D3AD0 estart=1748527203 eid=18875258 ctx=0x0000000777968158 cwh=0x00000000319D0AB8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-05-29 22:00:03.529703*:9DBAD27B:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000322D3AD0 curCtx=0x0000000040C688B0 pubTabIdxCnt=0 2025-05-29 22:00:03.529703*:9DBAD27C:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000322D3AD0 2025-05-29 22:00:03.529703*:9DBAD27D:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000322D3AD0 2025-05-29 22:00:03.529703*:9DBAD27E:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003231AAF8 estart=1748527201 eid=16777354 ctx=0x000000077B54EAC8 cwh=0x00000000319D0608 cpu=1625000 buffg=77827 interb=196608 r=24 rb=196608 w=0 wb=0 2025-05-29 22:00:03.529703*:9DBAD27F:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003231AAF8 curCtx=0x0000000040BD1240 pubTabIdxCnt=0 2025-05-29 22:00:03.529703*:9DBAD280:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003231AAF8 2025-05-29 22:00:03.529703*:9DBAD281:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003231AAF8 2025-05-29 22:00:03.529703*:9DBAD282:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000322D3AD0 curCtx=0x0000000040C688B0 xsc->flg4=65792 flags=1 2025-05-29 22:00:03.529703*:9DBAD283:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000322D3AD0 2025-05-29 22:00:03.554069 :9DBAD28E:db_trace:ktu.c@4871:ktuaex1r(): [10442:31:249] Extension usn 9, ext 1, nex 3 2025-05-29 22:00:03.554076 :9DBAD28F:db_trace:ktusm.c@2117:ktusmasp(): [10445:31:249] des1:tsn:1 rdba:0x008191c2 where: kdiwh22: kdifind 2025-05-29 22:00:03.560955*:9DBAD290:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003231AAF8 curCtx=0x0000000040BD1240 xsc->flg4=65792 flags=2 2025-05-29 22:00:03.560955*:9DBAD291:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003231AAF8 2025-05-29 22:00:03.568958 :9DBAD292:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:03.589520 :9DBAD29C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:03.591507 :9DBAD2A4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:psdpgi.c:2235 2025-05-29 22:00:03.591711 :9DBAD2A5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpop:psdpgi.c:2235 2025-05-29 22:00:03.592624 :9DBAD2A6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:03.592717 :9DBAD2A9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:03.593644 :9DBAD2BB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:03.595022 :9DBAD2C3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:03.595347 :9DBAD2CB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-05-29 22:00:03.743922 :9DBAD331:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:05.734663 :9DBAD3F6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:05.734676 :9DBAD3F7:db_trace:ktur.c@3079:ktuabt(): [10444:31:249] ABORT TRANSACTION - xid: 0x0001.015.0000c136 2025-05-29 22:00:08.419803 :9DBAD5C3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:08.421216 :9DBAD5CB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:08.431411 :9DBAD5D3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:08.454617 :9DBAD5DB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:09.679497 :9DBAD6EE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpop:jslv.c:9203 2025-05-29 22:00:09.693495 :9DBAD6EF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:0] KSL POST SENT postee=59 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:09.693891 :9DBAD6F7:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-29 22:00:17.838327 :9DBAD9F3:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-29 22:00:17.829 2025-05-29 22:00:17.838329 :9DBAD9F4:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=9964 pso_num=31 pso_serial#=164 2025-05-29 22:00:17.838459 :9DBAD9F5:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=9964 (legacy spawn) 2025-05-29 22:00:18.188923 :9DBADA02:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:18.189085 :9DBADA07:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-05-29 22:00:18.189826 :9DBADA0C:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-29 22:00:18.196749 :9DBADA0F:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-29 22:00:18.189 2025-05-29 22:00:18.196750 :9DBADA10:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=15352 pso_num=31 pso_serial#=165 2025-05-29 22:00:18.196880 :9DBADA11:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=15352 (legacy spawn) 2025-05-29 22:00:18.209037 :9DBADA12:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:18.209170 :9DBADA1B:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-05-29 22:00:18.209805 :9DBADA1C:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-29 22:00:18.918260 :9DBADA94:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-29 22:00:18.909 2025-05-29 22:00:18.918261 :9DBADA95:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=12700 pso_num=31 pso_serial#=166 2025-05-29 22:00:18.918402 :9DBADA96:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=12700 (legacy spawn) 2025-05-29 22:00:18.924863 :9DBADA97:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 22:00:18.925009 :9DBADAA0:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-05-29 22:00:18.925721 :9DBADAA1:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-29 23:59:13.331412 :9DC444DE:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-29 23:59:13.318 2025-05-29 23:59:13.331414 :9DC444DF:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14352 pso_num=31 pso_serial#=167 2025-05-29 23:59:13.331548 :9DC444E0:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=14352 (legacy spawn) 2025-05-29 23:59:13.345863 :9DC444E1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 23:59:46.483927 :9DC450E3:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-29 23:59:54.802129 :9DC45427:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-29 23:59:54.793 2025-05-29 23:59:54.802131 :9DC45428:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=13584 pso_num=31 pso_serial#=168 2025-05-29 23:59:54.802300 :9DC45429:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=13584 (legacy spawn) 2025-05-29 23:59:54.816320 :9DC4542A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 23:59:58.045986 :9DC45514:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-29 23:59:58.046171 :9DC45519:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-05-29 23:59:58.047410 :9DC4551E:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-29 23:59:58.296513 :9DC4552E:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-29 23:59:58.285 2025-05-29 23:59:58.296515 :9DC4552F:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=13632 pso_num=31 pso_serial#=169 2025-05-29 23:59:58.296640 :9DC45530:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=13632 (legacy spawn) 2025-05-29 23:59:58.310695 :9DC4553D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-30 00:06:18.266814 :9DC4DF21:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-30 00:06:18.266978 :9DC4DF29:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-05-30 00:06:18.268093 :9DC4DF2B:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-30 22:00:01.995088 :9E2BD547:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-30 22:00:01.991 2025-05-30 22:00:01.995089 :9E2BD548:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14708 pso_num=31 pso_serial#=170 2025-05-30 22:00:01.995218 :9E2BD549:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=14708 osp_idx=29 osp_ver=424 osp_pg=0 (spawn #235811) 2025-05-30 22:00:01.995219 :9E2BD54A:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-05-30 22:00:01.995219 :9E2BD54B:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=139 time=1618160625 2025-05-30 22:00:01.995220 :9E2BD54C:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-05-30 22:00:01.995220 :9E2BD54D:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-05-30 22:00:01.995221 :9E2BD54E:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-05-30 22:00:01.995221 :9E2BD54F:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-30 22:00:01.995222 :9E2BD550:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-30 22:00:01.995814 :9E2BD562:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-05-30 22:00:32.084638 :9E2BE9C2:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-30 23:59:16.458548 :9E352F1F:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-30 23:59:16.451 2025-05-30 23:59:16.458550 :9E352F20:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=12656 pso_num=31 pso_serial#=171 2025-05-30 23:59:16.458747 :9E352F21:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=12656 (legacy spawn) 2025-05-30 23:59:16.465182 :9E352F22:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-30 23:59:16.465363 :9E352F27:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-05-30 23:59:16.466427 :9E352F2C:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-30 23:59:16.475278 :9E352F2F:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-30 23:59:16.467 2025-05-30 23:59:16.475280 :9E352F30:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14392 pso_num=31 pso_serial#=172 2025-05-30 23:59:16.475417 :9E352F31:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=14392 (legacy spawn) 2025-05-30 23:59:16.482104 :9E352F32:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-30 23:59:16.482275 :9E352F3B:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-05-30 23:59:16.483127 :9E352F3C:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-30 23:59:17.942949 :9E352FCC:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-30 23:59:17.942 2025-05-30 23:59:17.942951 :9E352FCD:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14844 pso_num=31 pso_serial#=173 2025-05-30 23:59:17.943090 :9E352FCE:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=14844 (legacy spawn) 2025-05-30 23:59:17.956895 :9E352FCF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-30 23:59:21.229606 :9E3530D0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-30 23:59:21.229779 :9E3530D5:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-05-30 23:59:21.231150 :9E3530DA:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-30 23:59:21.492196 :9E3530FC:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-30 23:59:21.479 2025-05-30 23:59:21.492199 :9E3530FD:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=13500 pso_num=31 pso_serial#=174 2025-05-30 23:59:21.492345 :9E3530FE:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=13500 (legacy spawn) 2025-05-30 23:59:21.506503 :9E3530FF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-30 23:59:54.668661 :9E353D24:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-30 23:59:54.803070 :9E353D27:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-30 23:59:54.790 2025-05-30 23:59:54.803072 :9E353D28:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=13128 pso_num=31 pso_serial#=175 2025-05-30 23:59:54.803206 :9E353D29:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=13128 (legacy spawn) 2025-05-30 23:59:54.817391 :9E353D2A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-30 23:59:58.055802 :9E353E28:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-30 23:59:58.055973 :9E353E31:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-05-30 23:59:58.057160 :9E353E32:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-30 23:59:58.306480 :9E353E41:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-30 23:59:58.301 2025-05-30 23:59:58.306482 :9E353E42:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=12148 pso_num=31 pso_serial#=176 2025-05-30 23:59:58.306623 :9E353E43:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=12148 (legacy spawn) 2025-05-30 23:59:58.320861 :9E353E44:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-31 00:06:18.286116 :9E35C864:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-31 00:06:18.286285 :9E35C86C:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-05-31 00:06:18.287282 :9E35C86E:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-31 06:00:02.073733 :9E511EDB:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-31 06:00:02.071 2025-05-31 06:00:02.073734 :9E511EDC:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=12592 pso_num=31 pso_serial#=177 2025-05-31 06:00:02.073858 :9E511EDD:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=12592 osp_idx=29 osp_ver=431 osp_pg=0 (spawn #236924) 2025-05-31 06:00:02.073859 :9E511EDE:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-05-31 06:00:02.073860 :9E511EDF:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=140 time=1646960704 2025-05-31 06:00:02.073860 :9E511EE0:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-05-31 06:00:02.073861 :9E511EE1:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-05-31 06:00:02.073861 :9E511EE2:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-05-31 06:00:02.073862 :9E511EE3:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-31 06:00:02.073862 :9E511EE4:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-31 06:00:02.074435 :9E511EF6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-05-31 06:00:02.181121 :9E512156:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 31 (osid: 12592, J005)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de