Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250705060006\orcl_j003_12108_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250705060006\orcl_j003_12108_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:37559M/63366M, Ph+PgF:43475M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 12108, image: ORACLE.EXE (J003) *** 2025-07-05 06:00:06.115 *** SESSION ID:(233.28025) 2025-07-05 06:00:06.115 *** 2025-07-05 06:00:06.115 Process diagnostic dump for ORACLE.EXE (J003), OS id=12108, pid: 29, proc_ser: 196, sid: 233, sess_ser: 28025 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 12108 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J003) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12698, hash value=3498532843 Current Wait Stack: Not in wait; last wait ended 3.049504 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 3.049529 sec since last wait 0: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0xc9, filetype=0x2 wait_id=39 seq_num=40 snap_id=1 wait times: snap=0.000147 sec, exc=0.000147 sec, total=0.000147 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.064503 sec of elapsed time 1: waited for 'asynch descriptor resize' outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82 wait_id=38 seq_num=39 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.757914 sec of elapsed time 2: 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.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.025294 sec of elapsed time 3: 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.000003 sec, exc=0.000003 sec, total=0.000003 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.012786 sec of elapsed time 4: 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.000116 sec, exc=0.000116 sec, total=0.000116 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.049041 sec of elapsed time 5: 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.001815 sec, exc=0.001815 sec, total=0.001815 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007958 sec of elapsed time 6: 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.007592 sec, exc=0.007592 sec, total=0.007592 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.261914 sec of elapsed time 7: 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.000145 sec, exc=0.000145 sec, total=0.000145 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000319 sec of elapsed time 8: 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.006330 sec, exc=0.006330 sec, total=0.006330 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007835 sec of elapsed time 9: waited for 'asynch descriptor resize' outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82 wait_id=30 seq_num=31 snap_id=1 wait times: snap=0.000001 sec, exc=0.000001 sec, total=0.000001 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.000057 sec of elapsed time Sampled Session History of session 233 serial 28025 --------------------------------------------------- The sampled session history is constructed by sampling the target session every 1 second. The sampling process captures at each sample if the session is in a non-idle wait, an idle wait, or not in a wait. If the session is in a non-idle wait then one interval is shown for all the samples the session was in the same non-idle wait. If the session is in an idle wait or not in a wait for consecutive samples then one interval is shown for all the consecutive samples. Though we display these consecutive samples in a single interval the session may NOT be continuously idle or not in a wait (the sampling process does not know). The history is displayed in reverse chronological order. sample interval: 1 sec, max history 120 sec --------------------------------------------------- [4 samples, 06:00:02 - 06:00:05] not in wait at each sample [1 sample, 06:00:01] idle wait at each sample [session created at: 06:00:01] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-05 06:00:06.115 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 12108, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-05 01:00:07.470401 :ADA1F815:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=1420 pso_num=29 pso_serial#=188 2025-07-05 01:00:07.470536 :ADA1F816:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=1420 (legacy spawn) 2025-07-05 01:00:07.477008 :ADA1F817:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:07.477178 :ADA1F81C:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-05 01:00:07.477983 :ADA1F821:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-05 01:00:16.299687 :ADA1FADF:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-05 01:00:16.285 2025-07-05 01:00:16.299689 :ADA1FAE0:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=15432 pso_num=29 pso_serial#=189 2025-07-05 01:00:16.299825 :ADA1FAE1:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=15432 (legacy spawn) 2025-07-05 01:00:16.306306 :ADA1FAE2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:16.306479 :ADA1FAE7:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-05 01:00:16.307265 :ADA1FAEC:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-05 01:00:16.315935 :ADA1FAEF:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-05 01:00:16.300 2025-07-05 01:00:16.315937 :ADA1FAF0:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=14940 pso_num=29 pso_serial#=190 2025-07-05 01:00:16.316073 :ADA1FAF1:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=14940 (legacy spawn) 2025-07-05 01:00:16.322637 :ADA1FAF2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:16.322804 :ADA1FAFB:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-05 01:00:16.323587 :ADA1FAFC:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-05 01:00:19.534892 :ADA1FBEE:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-05 01:00:19.521 2025-07-05 01:00:19.534894 :ADA1FBEF:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=12284 pso_num=29 pso_serial#=191 2025-07-05 01:00:19.535032 :ADA1FBF0:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=12284 (legacy spawn) 2025-07-05 01:00:19.541502 :ADA1FBF1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:19.541673 :ADA1FBF6:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-05 01:00:19.542462 :ADA1FBFB:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-05 01:00:19.561515 :ADA1FBFE:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-05 01:00:19.552 2025-07-05 01:00:19.561517 :ADA1FBFF:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=14688 pso_num=29 pso_serial#=192 2025-07-05 01:00:19.561664 :ADA1FC00:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=14688 (legacy spawn) 2025-07-05 01:00:19.568083 :ADA1FC01:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:19.568245 :ADA1FC09:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-05 01:00:19.569082 :ADA1FC0B:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-05 01:00:24.348170 :ADA1FDCD:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-05 01:00:24.343 2025-07-05 01:00:24.348173 :ADA1FDCE:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=13500 pso_num=29 pso_serial#=193 2025-07-05 01:00:24.348306 :ADA1FDCF:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=13500 osp_idx=27 osp_ver=13962 osp_pg=0 (spawn #352911) 2025-07-05 01:00:24.348307 :ADA1FDD0:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-05 01:00:24.348308 :ADA1FDD1:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=75 time=358000236 2025-07-05 01:00:24.348308 :ADA1FDD2:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-05 01:00:24.348308 :ADA1FDD3:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-05 01:00:24.348309 :ADA1FDD4:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-05 01:00:24.348309 :ADA1FDD5:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-05 01:00:24.348309 :ADA1FDD6:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-05 01:00:24.348794 :ADA1FDD7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.348838 :ADA1FDDD:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-05 01:00:24.353300 :ADA1FDF0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.376178 :ADA1FDF8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.385254 :ADA1FE00:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.385266 :ADA1FE01:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x000a.009.00171465 2025-07-05 01:00:24.385836 :ADA1FE09:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 10, ext 1, nex 3 2025-07-05 01:00:24.385843 :ADA1FE0A:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x0081244e where: kdiwh187: kdisprobe 2025-07-05 01:00:24.392359 :ADA1FE0B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.420693 :ADA1FE13:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.424281 :ADA1FE1B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.424605 :ADA1FE23:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.428210 :ADA1FE2B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.430836 :ADA1FE33:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.432433 :ADA1FE3B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.433567 :ADA1FE43:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:24.437086 :ADA1FE4B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:25.483558*:ADA1FE6C:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002B561170 estart=1751648424 eid=16779715 ctx=0x000000077BA4B1C8 cwh=0x000000002B520500 cpu=421875 buffg=0 interb=0 r=0 rb=0 w=0 wb=0 2025-07-05 01:00:25.483558*:ADA1FE6D:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002B561170 curCtx=0x000000002DB0F998 pubTabIdxCnt=0 2025-07-05 01:00:25.483558*:ADA1FE6E:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002B561170 2025-07-05 01:00:25.483558*:ADA1FE6F:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002B561170 2025-07-05 01:00:25.483558*:ADA1FE70:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002B5326A0 estart=1751648424 eid=16779701 ctx=0x0000000787AD5BF0 cwh=0x000000002B5206E0 cpu=421875 buffg=0 interb=0 r=0 rb=0 w=0 wb=0 2025-07-05 01:00:25.483558*:ADA1FE71:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002B5326A0 curCtx=0x000000002B562110 pubTabIdxCnt=0 2025-07-05 01:00:25.483558*:ADA1FE72:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002B5326A0 2025-07-05 01:00:25.483558*:ADA1FE73:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002B5326A0 2025-07-05 01:00:25.608554*:ADA1FE81:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002B561170 curCtx=0x000000002DB0F998 xsc->flg4=65792 flags=1 2025-07-05 01:00:25.608554*:ADA1FE82:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002B561170 2025-07-05 01:00:25.608554*:ADA1FE83:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002B5326A0 curCtx=0x000000002B562110 xsc->flg4=65792 flags=2 2025-07-05 01:00:25.608554*:ADA1FE84:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002B5326A0 2025-07-05 01:00:25.688205 :ADA1FE85:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:25.723472 :ADA1FE8D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:25.723768 :ADA1FE95:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:25.724035 :ADA1FE9D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:25.724050 :ADA1FEA0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=18 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 01:00:25.724111 :ADA1FEAE:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-05 01:00:25.726762 :ADA1FEC1:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-05 01:01:24.492714 :ADA213C0:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-05 01:01:24.480 2025-07-05 01:01:24.492716 :ADA213C1:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18036 pso_num=29 pso_serial#=194 2025-07-05 01:01:24.492849 :ADA213C2:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=18036 osp_idx=27 osp_ver=13963 osp_pg=0 (spawn #352916) 2025-07-05 01:01:24.492850 :ADA213C3:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-05 01:01:24.492851 :ADA213C4:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=76 time=358060376 2025-07-05 01:01:24.492851 :ADA213C5:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-05 01:01:24.492851 :ADA213C6:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-05 01:01:24.492852 :ADA213C7:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-05 01:01:24.492852 :ADA213C8:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-05 01:01:24.492852 :ADA213C9:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-05 01:01:24.493354 :ADA213CA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-05 01:01:24.493393 :ADA213D0:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-05 01:01:24.501142 :ADA213E2:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-05 01:16:26.290554 :ADA341B1:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-05 01:16:26.278 2025-07-05 01:16:26.290556 :ADA341B2:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=15404 pso_num=29 pso_serial#=195 2025-07-05 01:16:26.290689 :ADA341B3:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=15404 osp_idx=27 osp_ver=13964 osp_pg=0 (spawn #352950) 2025-07-05 01:16:26.290690 :ADA341B4:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-05 01:16:26.290691 :ADA341B5:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=77 time=358962173 2025-07-05 01:16:26.290691 :ADA341B6:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-05 01:16:26.290692 :ADA341B7:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-05 01:16:26.290692 :ADA341B8:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-05 01:16:26.290692 :ADA341B9:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-05 01:16:26.290693 :ADA341BA:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-05 01:16:26.291258 :ADA341BB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-05 01:16:26.291308 :ADA341C1:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-05 01:16:26.295398 :ADA341DA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-05 01:16:26.295461 :ADA341DB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-05 01:16:26.295768 :ADA341DC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-05 01:16:26.295784 :ADA341DD:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-05 01:16:26.295998 :ADA341DE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-05 01:16:26.296012 :ADA341DF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-05 01:16:26.296225 :ADA341E0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-05 01:16:26.296238 :ADA341E1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-05 01:16:26.296448 :ADA341E2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-05 01:16:26.296461 :ADA341E3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-05 01:16:26.296668 :ADA341E4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-05 01:16:26.296680 :ADA341E5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-05 01:16:26.299113 :ADA341E6:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-05 06:00:01.213302 :ADB968EA:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-05 06:00:01.205 2025-07-05 06:00:01.213302 :ADB968EB:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=12108 pso_num=29 pso_serial#=196 2025-07-05 06:00:01.213451 :ADB968F1:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=12108 osp_idx=27 osp_ver=13965 osp_pg=0 (spawn #353609) 2025-07-05 06:00:01.213452 :ADB968F2:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-05 06:00:01.213452 :ADB968F3:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=78 time=375977111 2025-07-05 06:00:01.213453 :ADB968F4:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-05 06:00:01.213454 :ADB968F5:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-05 06:00:01.213454 :ADB968F6:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-05 06:00:01.213456 :ADB968F7:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-05 06:00:01.213456 :ADB968F8:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-05 06:00:01.214099 :ADB96901:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.219395 :ADB96919:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.219435 :ADB9691A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-07-05 06:00:01.237356 :ADB969A9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.237623 :ADB969B1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.237799 :ADB969B9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.237972 :ADB969C1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.238155 :ADB969C9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.238334 :ADB969D1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.238498 :ADB969D9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.238655 :ADB969E1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.238817 :ADB969E9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.238981 :ADB969F1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.239143 :ADB969F9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.239306 :ADB96A01:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.239478 :ADB96A09:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.239642 :ADB96A11:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.239800 :ADB96A19:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.239974 :ADB96A21:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.240131 :ADB96A29:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.240286 :ADB96A31:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.240445 :ADB96A39:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.240603 :ADB96A41:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.240754 :ADB96A49:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.240907 :ADB96A51:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.241580 :ADB96A59:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:01.270262 :ADB96A90:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:02.549330*:ADB96EE7:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000030183AD0 estart=1751666401 eid=20034678 ctx=0x0000000777968158 cwh=0x000000004B1B0158 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-07-05 06:00:02.549330*:ADB96EE8:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000030183AD0 curCtx=0x000000004B0B1BF8 pubTabIdxCnt=0 2025-07-05 06:00:02.549330*:ADB96EE9:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000030183AD0 2025-07-05 06:00:02.549330*:ADB96EEA:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000030183AD0 2025-07-05 06:00:02.549330*:ADB96EEB:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000301FB6F0 estart=1751666400 eid=16777431 ctx=0x000000077B54EAC8 cwh=0x00000000301F0068 cpu=1015625 buffg=58104 interb=196608 r=24 rb=196608 w=0 wb=0 2025-07-05 06:00:02.549330*:ADB96EEC:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000301FB6F0 curCtx=0x0000000034677FD8 pubTabIdxCnt=0 2025-07-05 06:00:02.549330*:ADB96EED:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000301FB6F0 2025-07-05 06:00:02.549330*:ADB96EEE:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000301FB6F0 2025-07-05 06:00:02.549330*:ADB96EEF:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000030183AD0 curCtx=0x000000004B0B1BF8 xsc->flg4=65792 flags=1 2025-07-05 06:00:02.549330*:ADB96EF0:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000030183AD0 2025-07-05 06:00:02.987920*:ADB96FE6:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000301FB6F0 curCtx=0x0000000034677FD8 xsc->flg4=65792 flags=2 2025-07-05 06:00:02.987920*:ADB96FE7:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000301FB6F0 2025-07-05 06:00:02.988474 :ADB96FE8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:03.008750 :ADB96FF0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:03.010755 :ADB96FF8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-07-05 06:00:03.010962 :ADB96FF9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-07-05 06:00:03.011870 :ADB96FFA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:03.011968 :ADB96FFD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:03.012854 :ADB9700F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:03.014359 :ADB97017:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:03.014659 :ADB9701F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:03.112918*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-07-05 06:00:03.112918*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-05 06:00:03.112918*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-05 06:00:03.159799*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-07-05 06:00:03.159799*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-07-05 06:00:03.159799*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-05 06:00:03.159799*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-05 06:00:03.222770 :ADB97046:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:05.141148 :ADB9712D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-05 06:00:05.141160 :ADB9712E:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x000a.00f.001714fd ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 29 (osid: 12108, J003)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de