Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250802220651\orcl_ora_20216_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:35820M/63366M, Ph+PgF:41461M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 35 Windows thread id: 20216, image: ORACLE.EXE (SHAD) *** 2025-08-02 22:06:51.346 *** 2025-08-02 22:06:51.346 Process diagnostic dump for ORACLE.EXE (SHAD), OS id=20216, pid: 35, proc_ser: 61, sid: ------------------------------------------------------------------------------- Skipping session state dump because target process has no session. ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-02 22:06:51.346 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 35 (osid: 20216) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-24 23:59:40.492073 :B68AF945:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-24 23:59:53.828490 :B68AFE21:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-24 23:59:53.817 2025-07-24 23:59:53.828493 :B68AFE22:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=680 pso_num=35 pso_serial#=42 2025-07-24 23:59:53.828608 :B68AFE23:db_trace:kso.c@4093:ksonfy(): [10420:35:0] kso: new process: pid=680 osp_idx=33 osp_ver=296 osp_pg=0 (spawn #419436) 2025-07-24 23:59:53.828609 :B68AFE24:db_trace:kso.c@4099:ksonfy(): [10420:35:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-24 23:59:53.828609 :B68AFE25:db_trace:kso.c@4103:ksonfy(): [10420:35:0] kso: new process: pso_index=35 reservation=63 time=2082369720 2025-07-24 23:59:53.828610 :B68AFE26:db_trace:kso.c@4109:ksonfy(): [10420:35:0] kso: spawn diagnostics: queue time=0 secs 2025-07-24 23:59:53.828610 :B68AFE27:db_trace:kso.c@4111:ksonfy(): [10420:35:0] kso: spawn diagnostics: fork time=0 secs 2025-07-24 23:59:53.828610 :B68AFE28:db_trace:kso.c@4113:ksonfy(): [10420:35:0] kso: spawn diagnostics: exec time=0 secs 2025-07-24 23:59:53.828613 :B68AFE29:db_trace:kso.c@4115:ksonfy(): [10420:35:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-24 23:59:53.828613 :B68AFE2A:db_trace:kso.c@4117:ksonfy(): [10420:35:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-24 23:59:53.829110 :B68AFE2B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-25 00:00:23.868621 :B68B098D:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-25 23:59:23.461868 :B6FC641E:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-25 23:59:23.452 2025-07-25 23:59:23.461870 :B6FC641F:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=17044 pso_num=35 pso_serial#=43 2025-07-25 23:59:23.462010 :B6FC6420:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=17044 (legacy spawn) 2025-07-25 23:59:23.468903 :B6FC6421:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-25 23:59:23.469085 :B6FC6426:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-07-25 23:59:23.469905 :B6FC642B:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-25 23:59:26.527951 :B6FC6552:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-25 23:59:26.514 2025-07-25 23:59:26.527953 :B6FC6553:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=16104 pso_num=35 pso_serial#=44 2025-07-25 23:59:26.528102 :B6FC6554:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=16104 (legacy spawn) 2025-07-25 23:59:26.543124 :B6FC6555:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-26 00:00:00.051942 :B6FC719B:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-26 00:00:00.258931 :B6FC719E:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-26 00:00:00.252 2025-07-26 00:00:00.258934 :B6FC719F:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=14636 pso_num=35 pso_serial#=45 2025-07-26 00:00:00.259078 :B6FC71A0:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=14636 (legacy spawn) 2025-07-26 00:00:00.274010 :B6FC71A1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-26 00:06:20.238291 :B6FCFA2C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-26 00:06:20.238453 :B6FCFA31:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-07-26 00:06:20.239602 :B6FCFA36:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-26 23:59:50.776053 :B76D5185:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-26 23:59:50.769 2025-07-26 23:59:50.776055 :B76D5186:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=11176 pso_num=35 pso_serial#=46 2025-07-26 23:59:50.776199 :B76D5187:db_trace:kso.c@4093:ksonfy(): [10420:35:0] kso: new process: pid=11176 osp_idx=33 osp_ver=300 osp_pg=0 (spawn #426100) 2025-07-26 23:59:50.776199 :B76D5188:db_trace:kso.c@4099:ksonfy(): [10420:35:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-26 23:59:50.776200 :B76D5189:db_trace:kso.c@4103:ksonfy(): [10420:35:0] kso: new process: pso_index=35 reservation=64 time=2255166673 2025-07-26 23:59:50.776200 :B76D518A:db_trace:kso.c@4109:ksonfy(): [10420:35:0] kso: spawn diagnostics: queue time=0 secs 2025-07-26 23:59:50.776200 :B76D518B:db_trace:kso.c@4111:ksonfy(): [10420:35:0] kso: spawn diagnostics: fork time=0 secs 2025-07-26 23:59:50.776201 :B76D518C:db_trace:kso.c@4113:ksonfy(): [10420:35:0] kso: spawn diagnostics: exec time=0 secs 2025-07-26 23:59:50.776201 :B76D518D:db_trace:kso.c@4115:ksonfy(): [10420:35:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-26 23:59:50.776202 :B76D518E:db_trace:kso.c@4117:ksonfy(): [10420:35:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-26 23:59:50.776777 :B76D518F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-26 23:59:50.777528 :B76D51A4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-26 23:59:50.785834 :B76D51C0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:35:26] atxpus:psdpgi.c:2235 2025-07-26 23:59:50.786351 :B76D51C1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-26 23:59:50.786390 :B76D51C4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:35:26] atxpop:psdpgi.c:2235 2025-07-26 23:59:50.787366 :B76D51CA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-26 23:59:50.787491 :B76D51D3:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-07-27 00:00:15.800914 :B76D5A97:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-07-27 00:00:15.800937*:B76D5A99:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002DD2BB58 estart=1753545615 eid=16976371 ctx=0x000000077BD98A08 cwh=0x000000002DCE02A0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-07-27 00:00:15.800937*:B76D5A9A:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002DD2BB58 curCtx=0x000000002DCED678 pubTabIdxCnt=0 2025-07-27 00:00:15.800937*:B76D5A9B:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002DD2BB58 2025-07-27 00:00:15.800937*:B76D5A9C:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002DD2BB58 2025-07-27 00:00:15.800937*:B76D5A9D:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002DD2BB58 curCtx=0x000000002DCED678 xsc->flg4=65792 flags=2 2025-07-27 00:00:15.800937*:B76D5A9E:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002DD2BB58 2025-07-27 00:00:15.801493 :B76D5A9F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-27 00:00:15.806873 :B76D5AA2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-27 00:00:15.893098 :B76D5AB5:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-07-27 00:00:45.925160 :B76D64C6:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-27 23:59:34.343089 :B7DF33C1:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-27 23:59:34.329 2025-07-27 23:59:34.343091 :B7DF33C2:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=18916 pso_num=35 pso_serial#=47 2025-07-27 23:59:34.343236 :B7DF33C3:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=18916 (legacy spawn) 2025-07-27 23:59:34.350151 :B7DF33C4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-27 23:59:34.350334 :B7DF33CD:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-07-27 23:59:34.351257 :B7DF33CE:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-27 23:59:46.392738 :B7DF380D:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-27 23:59:46.378 2025-07-27 23:59:46.392741 :B7DF380E:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=1852 pso_num=35 pso_serial#=48 2025-07-27 23:59:46.392890 :B7DF380F:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=1852 (legacy spawn) 2025-07-27 23:59:46.399799 :B7DF3810:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-27 23:59:46.399982 :B7DF3819:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-07-27 23:59:46.400832 :B7DF381A:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-27 23:59:46.410344 :B7DF381D:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-27 23:59:46.409 2025-07-27 23:59:46.410346 :B7DF381E:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=7216 pso_num=35 pso_serial#=49 2025-07-27 23:59:46.410487 :B7DF381F:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=7216 (legacy spawn) 2025-07-27 23:59:46.417298 :B7DF3820:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-27 23:59:46.417453 :B7DF3827:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-07-27 23:59:46.418278 :B7DF382A:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-27 23:59:46.933184 :B7DF3851:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-27 23:59:46.926 2025-07-27 23:59:46.933186 :B7DF3852:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=18900 pso_num=35 pso_serial#=50 2025-07-27 23:59:46.933327 :B7DF3853:db_trace:kso.c@4093:ksonfy(): [10420:35:0] kso: new process: pid=18900 osp_idx=33 osp_ver=304 osp_pg=0 (spawn #429437) 2025-07-27 23:59:46.933327 :B7DF3854:db_trace:kso.c@4099:ksonfy(): [10420:35:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-27 23:59:46.933328 :B7DF3855:db_trace:kso.c@4103:ksonfy(): [10420:35:0] kso: new process: pso_index=35 reservation=65 time=2341562829 2025-07-27 23:59:46.933328 :B7DF3856:db_trace:kso.c@4109:ksonfy(): [10420:35:0] kso: spawn diagnostics: queue time=0 secs 2025-07-27 23:59:46.933328 :B7DF3857:db_trace:kso.c@4111:ksonfy(): [10420:35:0] kso: spawn diagnostics: fork time=0 secs 2025-07-27 23:59:46.933328 :B7DF3858:db_trace:kso.c@4113:ksonfy(): [10420:35:0] kso: spawn diagnostics: exec time=0 secs 2025-07-27 23:59:46.933329 :B7DF3859:db_trace:kso.c@4115:ksonfy(): [10420:35:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-27 23:59:46.933329 :B7DF385A:db_trace:kso.c@4117:ksonfy(): [10420:35:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-27 23:59:46.933880 :B7DF385B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-27 23:59:46.934610 :B7DF3870:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-27 23:59:46.943150 :B7DF388C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:35:26] atxpus:psdpgi.c:2235 2025-07-27 23:59:46.943544 :B7DF388D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-27 23:59:46.943576 :B7DF3890:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:35:26] atxpop:psdpgi.c:2235 2025-07-27 23:59:46.944535 :B7DF3896:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-27 23:59:46.944658 :B7DF389F:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-07-28 00:00:17.038168 :B7DF42D1:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-28 23:59:34.619923 :B84FD396:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-28 23:59:34.615 2025-07-28 23:59:34.619925 :B84FD397:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=18704 pso_num=35 pso_serial#=51 2025-07-28 23:59:34.620068 :B84FD398:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=18704 (legacy spawn) 2025-07-28 23:59:34.635032 :B84FD399:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-29 00:00:07.744388 :B84FE034:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-29 23:59:35.054849 :B8C01385:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-29 23:59:35.054 2025-07-29 23:59:35.054850 :B8C01386:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=19540 pso_num=35 pso_serial#=52 2025-07-29 23:59:35.055007 :B8C01387:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=19540 (legacy spawn) 2025-07-29 23:59:35.070777 :B8C01388:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-30 00:00:08.057213 :B8C01F7A:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-30 23:59:34.302946 :B933ED37:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-30 23:59:34.298 2025-07-30 23:59:34.302948 :B933ED38:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=19388 pso_num=35 pso_serial#=53 2025-07-30 23:59:34.303102 :B933ED39:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=19388 (legacy spawn) 2025-07-30 23:59:34.319241 :B933ED3A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-31 00:00:07.569206 :B933F911:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-31 23:59:34.857967 :B9A5E2A3:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-31 23:59:34.847 2025-07-31 23:59:34.857969 :B9A5E2A4:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=19528 pso_num=35 pso_serial#=54 2025-07-31 23:59:34.858098 :B9A5E2A5:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=19528 (legacy spawn) 2025-07-31 23:59:34.864648 :B9A5E2A6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-31 23:59:34.864818 :B9A5E2AF:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-07-31 23:59:34.865622 :B9A5E2B0:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-31 23:59:50.783719 :B9A5E836:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-31 23:59:50.775 2025-07-31 23:59:50.783722 :B9A5E837:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=18400 pso_num=35 pso_serial#=55 2025-07-31 23:59:50.783859 :B9A5E838:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=18400 (legacy spawn) 2025-07-31 23:59:50.790577 :B9A5E839:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-31 23:59:50.790773 :B9A5E841:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-07-31 23:59:50.791627 :B9A5E842:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-07-31 23:59:53.445084 :B9A5E939:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 07-31 23:59:53.438 2025-07-31 23:59:53.445086 :B9A5E93A:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=11764 pso_num=35 pso_serial#=56 2025-07-31 23:59:53.445234 :B9A5E93B:db_trace:kso.c@4093:ksonfy(): [10420:35:0] kso: new process: pid=11764 osp_idx=33 osp_ver=310 osp_pg=0 (spawn #442760) 2025-07-31 23:59:53.445235 :B9A5E93C:db_trace:kso.c@4099:ksonfy(): [10420:35:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-31 23:59:53.445235 :B9A5E93D:db_trace:kso.c@4103:ksonfy(): [10420:35:0] kso: new process: pso_index=35 reservation=66 time=2687169329 2025-07-31 23:59:53.445236 :B9A5E93E:db_trace:kso.c@4109:ksonfy(): [10420:35:0] kso: spawn diagnostics: queue time=0 secs 2025-07-31 23:59:53.445236 :B9A5E93F:db_trace:kso.c@4111:ksonfy(): [10420:35:0] kso: spawn diagnostics: fork time=0 secs 2025-07-31 23:59:53.445236 :B9A5E940:db_trace:kso.c@4113:ksonfy(): [10420:35:0] kso: spawn diagnostics: exec time=0 secs 2025-07-31 23:59:53.445237 :B9A5E941:db_trace:kso.c@4115:ksonfy(): [10420:35:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-31 23:59:53.445237 :B9A5E942:db_trace:kso.c@4117:ksonfy(): [10420:35:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-31 23:59:53.445950 :B9A5E943:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-31 23:59:53.446734 :B9A5E958:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-31 23:59:53.456196 :B9A5E974:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:35:26] atxpus:psdpgi.c:2235 2025-07-31 23:59:53.456604 :B9A5E975:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-31 23:59:53.456637 :B9A5E978:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:35:26] atxpop:psdpgi.c:2235 2025-07-31 23:59:53.457662 :B9A5E97E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-31 23:59:53.457758 :B9A5E987:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-01 00:00:18.477447 :B9A5F647:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-01 00:00:18.477469*:B9A5F64A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003129BB58 estart=1753977618 eid=16984305 ctx=0x000000077BD98A08 cwh=0x00000000310102A0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-08-01 00:00:18.477469*:B9A5F64B:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003129BB58 curCtx=0x000000003101F300 pubTabIdxCnt=0 2025-08-01 00:00:18.477469*:B9A5F64C:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003129BB58 2025-08-01 00:00:18.477469*:B9A5F64D:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003129BB58 2025-08-01 00:00:18.477469*:B9A5F64E:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003129BB58 curCtx=0x000000003101F300 xsc->flg4=65792 flags=2 2025-08-01 00:00:18.477469*:B9A5F64F:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003129BB58 2025-08-01 00:00:18.478024 :B9A5F650:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-01 00:00:18.483321 :B9A5F658:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-01 00:00:18.484185 :B9A5F660:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-01 00:00:18.484313 :B9A5F669:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-01 00:00:48.525956 :B9A6003D:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-08-01 23:59:23.680981 :BA17A187:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 08-01 23:59:23.681 2025-08-01 23:59:23.680983 :BA17A188:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=15328 pso_num=35 pso_serial#=57 2025-08-01 23:59:23.681152 :BA17A189:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=15328 (legacy spawn) 2025-08-01 23:59:23.687939 :BA17A18A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-01 23:59:23.688115 :BA17A192:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-01 23:59:23.688932 :BA17A194:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-08-01 23:59:23.698289 :BA17A197:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 08-01 23:59:23.696 2025-08-01 23:59:23.698291 :BA17A198:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=18448 pso_num=35 pso_serial#=58 2025-08-01 23:59:23.698437 :BA17A199:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=18448 (legacy spawn) 2025-08-01 23:59:23.705336 :BA17A19A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-01 23:59:23.705500 :BA17A1A3:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-01 23:59:23.706345 :BA17A1A4:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-08-01 23:59:26.994599 :BA17A2B9:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 08-01 23:59:26.981 2025-08-01 23:59:26.994601 :BA17A2BA:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=20052 pso_num=35 pso_serial#=59 2025-08-01 23:59:26.994753 :BA17A2BB:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=20052 (legacy spawn) 2025-08-01 23:59:27.001661 :BA17A2BC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-01 23:59:27.001831 :BA17A2C1:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-01 23:59:27.002683 :BA17A2C6:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-08-01 23:59:27.011687 :BA17A2C9:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 08-01 23:59:26.996 2025-08-01 23:59:27.011691 :BA17A2CA:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=18088 pso_num=35 pso_serial#=60 2025-08-01 23:59:27.011832 :BA17A2CB:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=18088 (legacy spawn) 2025-08-01 23:59:27.018650 :BA17A2CC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-01 23:59:27.018816 :BA17A2D5:db_trace:ksl2.c@12699:ksliwat(): [10005:35:26] 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-01 23:59:27.019624 :BA17A2D6:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted 2025-08-01 23:59:28.113827 :BA17A330:db_trace:kst.c@673:kstipg(): [10280:35:0] kst: process state object created on 08-01 23:59:28.102 2025-08-01 23:59:28.113830 :BA17A331:db_trace:kst.c@679:kstipg(): [10280:35:0] kst: process info: ospid=20216 pso_num=35 pso_serial#=61 2025-08-01 23:59:28.113973 :BA17A332:db_trace:kso.c@4070:ksonfy(): [10420:35:0] kso: new process: pid=20216 (legacy spawn) 2025-08-01 23:59:28.129328 :BA17A333:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:35:26] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-02 00:00:01.164512 :BA17AEF4:db_trace:kst.c@698:kstpsodel(): [10280:35:0] kst: process state object about to be deleted ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 35 (osid: 20216)