Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250810180926\orcl_j000_19756_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250810180926\orcl_j000_19756_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:35595M/63366M, Ph+PgF:41062M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 19756, image: ORACLE.EXE (J000) *** 2025-08-10 18:09:26.261 *** SESSION ID:(193.59437) 2025-08-10 18:09:26.261 *** 2025-08-10 18:09:26.261 Process diagnostic dump for ORACLE.EXE (J000), OS id=19756, pid: 24, proc_ser: 160, sid: 193, sess_ser: 59437 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 19756 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12901, hash value=798069579 Current Wait Stack: Not in wait; last wait ended 2.551188 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 2.551214 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.000171 sec, exc=0.000171 sec, total=0.000171 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.051080 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.000006 sec, exc=0.000006 sec, total=0.000006 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.757749 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.026979 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.000012 sec, exc=0.000012 sec, total=0.000012 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.012829 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.000115 sec, exc=0.000115 sec, total=0.000115 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.049702 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.004006 sec, exc=0.004006 sec, total=0.004006 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007809 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.000110 sec, exc=0.000110 sec, total=0.000110 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.261765 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.007351 sec, exc=0.007351 sec, total=0.007351 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000165 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.000115 sec, exc=0.000115 sec, total=0.000115 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007943 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.000054 sec of elapsed time Sampled Session History of session 193 serial 59437 --------------------------------------------------- The sampled session history is constructed by sampling the target session every 1 second. The sampling process captures at each sample if the session is in a non-idle wait, an idle wait, or not in a wait. If the session is in a non-idle wait then one interval is shown for all the samples the session was in the same non-idle wait. If the session is in an idle wait or not in a wait for consecutive samples then one interval is shown for all the consecutive samples. Though we display these consecutive samples in a single interval the session may NOT be continuously idle or not in a wait (the sampling process does not know). The history is displayed in reverse chronological order. sample interval: 1 sec, max history 120 sec --------------------------------------------------- [5 samples, 18:09:22 - 18:09:26] not in wait at each sample [1 sample, 18:09:21] idle wait at each sample [session created at: 18:09:21] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-10 18:09:26.261 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 19756, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-10 18:06:50.856436 :BDF5F7D9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 18:06:50.864476 :BDF5F7DF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:06:50.864539 :BDF5F7E2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-10 18:06:50.864571 :BDF5F7E3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-10 18:06:50.866289 :BDF5F7E9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 18:06:50.866334 :BDF5F7EA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 18:06:50.866460 :BDF5F7EB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 18:06:50.866489 :BDF5F7EC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 18:06:50.866514 :BDF5F7ED:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 18:06:50.866732 :BDF5F7EE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:06:50.866764 :BDF5F7F1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 18:06:50.871249 :BDF5F7F7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:06:50.871308 :BDF5F7FA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-08-10 18:06:50.871341 :BDF5F7FB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-08-10 18:06:50.871698 :BDF5F801:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-08-10 18:06:50.872049 :BDF5F802:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-08-10 18:06:50.872173 :BDF5F803:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 18:06:50.872412 :BDF5F804:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:06:50.872439 :BDF5F807:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 18:06:50.874059 :BDF5F80D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 18:06:50.874274 :BDF5F80E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:06:50.874303 :BDF5F811:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 18:06:50.875199 :BDF5F817:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:07:20.948195 :BDF601EC:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:07:23.238261 :BDF60270:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:07:23.227 2025-08-10 18:07:23.238263 :BDF60271:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19932 pso_num=24 pso_serial#=150 2025-08-10 18:07:23.238401 :BDF60272:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=19932 (legacy spawn) 2025-08-10 18:07:23.245311 :BDF60273:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:07:23.245478 :BDF60278:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-10 18:07:23.246325 :BDF6027D:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:07:47.297841 :BDF609D4:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:07:47.285 2025-08-10 18:07:47.297843 :BDF609D5:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21464 pso_num=24 pso_serial#=151 2025-08-10 18:07:47.297989 :BDF609D6:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=21464 (legacy spawn) 2025-08-10 18:07:47.304449 :BDF609D7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:07:47.304621 :BDF609E0:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-10 18:07:47.305434 :BDF609E1:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:07:50.878945 :BDF60B10:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:07:50.873 2025-08-10 18:07:50.878947 :BDF60B11:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18916 pso_num=24 pso_serial#=152 2025-08-10 18:07:50.879085 :BDF60B12:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=18916 osp_idx=22 osp_ver=706002 osp_pg=0 (spawn #475288) 2025-08-10 18:07:50.879086 :BDF60B13:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 18:07:50.879086 :BDF60B14:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=125 time=3529940189 2025-08-10 18:07:50.879087 :BDF60B15:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 18:07:50.879088 :BDF60B16:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 18:07:50.879088 :BDF60B17:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 18:07:50.879088 :BDF60B18:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 18:07:50.879089 :BDF60B19:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 18:07:50.879579 :BDF60B1A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 18:07:50.880215 :BDF60B2F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:07:50.887770 :BDF60B4B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 18:07:50.888127 :BDF60B4C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:07:50.888163 :BDF60B4F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 18:07:50.889206 :BDF60B61:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:07:50.889329 :BDF60B6A:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-10 18:08:20.988390 :BDF6150F:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:08:27.793093 :BDF61705:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:08:27.778 2025-08-10 18:08:27.793095 :BDF61706:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19948 pso_num=24 pso_serial#=153 2025-08-10 18:08:27.793230 :BDF61707:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=19948 (legacy spawn) 2025-08-10 18:08:27.799680 :BDF61708:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:08:27.799859 :BDF6170D:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-10 18:08:27.800673 :BDF61712:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:08:27.809450 :BDF61715:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:08:27.794 2025-08-10 18:08:27.809452 :BDF61716:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20152 pso_num=24 pso_serial#=154 2025-08-10 18:08:27.809588 :BDF61717:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=20152 (legacy spawn) 2025-08-10 18:08:27.816047 :BDF6172B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:08:27.816207 :BDF61734:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-10 18:08:27.817003 :BDF61735:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:08:30.880248 :BDF6181B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:08:30.867 2025-08-10 18:08:30.880250 :BDF6181C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21228 pso_num=24 pso_serial#=155 2025-08-10 18:08:30.880390 :BDF6181D:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=21228 (legacy spawn) 2025-08-10 18:08:30.886970 :BDF6181E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:08:30.887159 :BDF61827:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-10 18:08:30.887997 :BDF61828:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:08:30.896768 :BDF6182B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:08:30.882 2025-08-10 18:08:30.896770 :BDF6182C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20488 pso_num=24 pso_serial#=156 2025-08-10 18:08:30.896907 :BDF6182D:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=20488 (legacy spawn) 2025-08-10 18:08:30.903480 :BDF6182E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:08:30.903649 :BDF61837:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-10 18:08:30.904518 :BDF61838:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:08:31.328832 :BDF61854:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:08:31.320 2025-08-10 18:08:31.328833 :BDF61855:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20008 pso_num=24 pso_serial#=157 2025-08-10 18:08:31.328977 :BDF61856:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=20008 (legacy spawn) 2025-08-10 18:08:31.335566 :BDF61857:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:08:31.335727 :BDF61860:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-10 18:08:31.336582 :BDF61861:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:08:50.984818 :BDF61E7D:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:08:50.979 2025-08-10 18:08:50.984820 :BDF61E7E:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=17016 pso_num=24 pso_serial#=158 2025-08-10 18:08:50.984956 :BDF61E7F:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=17016 osp_idx=22 osp_ver=706008 osp_pg=0 (spawn #475290) 2025-08-10 18:08:50.984956 :BDF61E80:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 18:08:50.984957 :BDF61E81:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=126 time=3530000283 2025-08-10 18:08:50.984957 :BDF61E82:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 18:08:50.984957 :BDF61E83:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 18:08:50.984958 :BDF61E84:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 18:08:50.984958 :BDF61E85:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 18:08:50.984958 :BDF61E86:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 18:08:50.985486 :BDF61E87:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 18:08:50.986145 :BDF61E9C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:08:50.997238 :BDF61EB8:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-08-10 18:08:50.997714 :BDF61EB9:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-08-10 18:08:51.000053 :BDF61EBA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 18:08:51.000376 :BDF61EBB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:08:51.000412 :BDF61EBE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 18:08:51.001349 :BDF61EC4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:08:51.001474 :BDF61ECD:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-10 18:09:21.089242 :BDF628C7:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:09:21.833217 :BDF628FE:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:09:21.828 2025-08-10 18:09:21.833219 :BDF628FF:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21496 pso_num=24 pso_serial#=159 2025-08-10 18:09:21.833359 :BDF62900:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=21496 osp_idx=22 osp_ver=706009 osp_pg=0 (spawn #475293) 2025-08-10 18:09:21.833359 :BDF62901:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 18:09:21.833360 :BDF62902:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=127 time=3530031142 2025-08-10 18:09:21.833360 :BDF62903:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 18:09:21.833361 :BDF62904:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 18:09:21.833361 :BDF62905:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 18:09:21.833361 :BDF62906:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 18:09:21.833362 :BDF62907:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 18:09:21.833874 :BDF62908:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.833920 :BDF6290E:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=18 loc='ksv2.h LINE:1639 ID:ksvpst: run' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-10 18:09:21.837936 :BDF62920:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-10 18:09:21.837989 :BDF62921:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-10 18:09:21.838244 :BDF62922:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-10 18:09:21.838260 :BDF62923:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-10 18:09:21.838478 :BDF62924:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-10 18:09:21.838492 :BDF62925:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-10 18:09:21.838701 :BDF62926:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-10 18:09:21.838714 :BDF62927:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-10 18:09:21.838918 :BDF62928:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-10 18:09:21.838930 :BDF62929:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-10 18:09:21.839136 :BDF6292A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-10 18:09:21.839149 :BDF6292B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-10 18:09:21.841590 :BDF62959:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 18:09:21.930695 :BDF62A56:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 18:09:21.922 2025-08-10 18:09:21.930698 :BDF62A57:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19756 pso_num=24 pso_serial#=160 2025-08-10 18:09:21.931073 :BDF62A58:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19756 osp_idx=22 osp_ver=706010 osp_pg=0 (spawn #475295) 2025-08-10 18:09:21.931075 :BDF62A59:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 18:09:21.931075 :BDF62A5A:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=128 time=3530031236 2025-08-10 18:09:21.931077 :BDF62A5B:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 18:09:21.931077 :BDF62A5C:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 18:09:21.931078 :BDF62A5D:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 18:09:21.931079 :BDF62A5E:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 18:09:21.931080 :BDF62A5F:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 18:09:21.932011 :BDF62A60:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.937085 :BDF62A7F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.937134 :BDF62A82:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:jslv.c:9203 2025-08-10 18:09:21.954120 :BDF62A98:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.954322 :BDF62AA0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.954522 :BDF62AA8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.954704 :BDF62AB0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.954857 :BDF62AB8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.955017 :BDF62AC0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.955175 :BDF62AC8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.955320 :BDF62AD0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.955471 :BDF62AD8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.955618 :BDF62AE0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.955769 :BDF62AE8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.955928 :BDF62AF0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.956068 :BDF62AF8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.956279 :BDF62B00:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.956426 :BDF62B08:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.956755 :BDF62B10:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.957007 :BDF62B18:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:21.975644 :BDF62B20:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:23.639833 :BDF62C5F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:23.660064 :BDF62C81:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:23.661953 :BDF62C89:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 18:09:23.662135 :BDF62C8A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 18:09:23.663088 :BDF62C8B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:23.663196 :BDF62C8E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:23.664081 :BDF62CA0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:23.665529 :BDF62CA8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:23.665808 :BDF62CB0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:23.702934*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-08-10 18:09:23.718566*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-08-10 18:09:23.718566*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-08-10 18:09:23.718566*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-08-10 18:09:23.718566*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-08-10 18:09:23.718566*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-08-10 18:09:23.718566*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-08-10 18:09:23.781120 :BDF62D4E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:25.650318 :BDF62DDF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 18:09:25.650330 :BDF62DE0:db_trace:ktur.c@3079:ktuabt(): [10444:24:193] ABORT TRANSACTION - xid: 0x000a.001.00177343 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 24 (osid: 19756, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de