Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250723220008\orcl_j000_9372_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250723220008\orcl_j000_9372_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:36038M/63366M, Ph+PgF:41842M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 9372, image: ORACLE.EXE (J000) *** 2025-07-23 22:00:08.183 *** SESSION ID:(193.38827) 2025-07-23 22:00:08.183 *** 2025-07-23 22:00:08.183 Process diagnostic dump for ORACLE.EXE (J000), OS id=9372, pid: 24, proc_ser: 175, sid: 193, sess_ser: 38827 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 9372 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.253898 sec, exc=0.253898 sec, total=0.253898 sec wait times: max=0.500000 sec, heur=1.739808 sec wait counts: calls=1 os=1 in_wait=1 iflags=0x5a8 Wait State: fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.000009 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.499997 sec, exc=0.499997 sec, total=0.499997 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 snap_id=1 wait times: snap=0.499978 sec, exc=0.499978 sec, total=0.499978 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000017 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.485899 sec, exc=0.485899 sec, total=0.485899 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000000 sec of elapsed time Sampled Session History of session 193 serial 38827 --------------------------------------------------- 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 --------------------------------------------------- [2 samples, 22:00:06 - 22:00:08] idle wait at each sample [session created at: 22:00:06] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-23 22:00:08.183 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 9372, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-23 21:59:26.017209 :B60F9346:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=1216 (legacy spawn) 2025-07-23 21:59:26.023699 :B60F9347: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-07-23 21:59:26.023865 :B60F9350: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-07-23 21:59:26.024692 :B60F9351:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-23 21:59:29.287600 :B60F9451:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-23 21:59:29.274 2025-07-23 21:59:29.287602 :B60F9452:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18540 pso_num=24 pso_serial#=173 2025-07-23 21:59:29.287738 :B60F9453:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=18540 (legacy spawn) 2025-07-23 21:59:29.294343 :B60F9454: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-07-23 21:59:29.294536 :B60F9459: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-07-23 21:59:29.295339 :B60F945E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-23 21:59:29.303974 :B60F9461:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-23 21:59:29.290 2025-07-23 21:59:29.303976 :B60F9462:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18148 pso_num=24 pso_serial#=174 2025-07-23 21:59:29.304112 :B60F9463:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=18148 (legacy spawn) 2025-07-23 21:59:29.310630 :B60F9464: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-07-23 21:59:29.310795 :B60F946C: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-07-23 21:59:29.311570 :B60F946E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-23 21:59:31.738121 :B60F9560:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-23 21:59:31.733 2025-07-23 21:59:31.738123 :B60F9561:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=9372 pso_num=24 pso_serial#=175 2025-07-23 21:59:31.738275 :B60F9562:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=9372 osp_idx=22 osp_ver=612950 osp_pg=0 (spawn #415813) 2025-07-23 21:59:31.738276 :B60F9563:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-23 21:59:31.738276 :B60F9564:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=232 time=1988747626 2025-07-23 21:59:31.738277 :B60F9565:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-07-23 21:59:31.738278 :B60F9566:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-07-23 21:59:31.738278 :B60F9567:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-07-23 21:59:31.738278 :B60F9568:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-23 21:59:31.738278 :B60F9569:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-23 21:59:31.738813 :B60F956A: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-07-23 21:59:31.739483 :B60F957F: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-07-23 21:59:31.746983 :B60F959C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-07-23 21:59:31.747348 :B60F959D: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-07-23 21:59:31.747382 :B60F95A0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-07-23 21:59:31.748245 :B60F95A6: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-07-23 21:59:31.748359 :B60F95AF: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-07-23 22:00:01.777621 :B60FA0EA:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-23 22:00:01.777621*:B60FA0FA:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024D5C718 estart=1753279201 eid=16784733 ctx=0x000000077FD6A000 cwh=0x0000000024D50068 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-07-23 22:00:01.777621*:B60FA0FB:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024D5C718 curCtx=0x0000000024D58938 pubTabIdxCnt=0 2025-07-23 22:00:01.777621*:B60FA0FC:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024D5C718 2025-07-23 22:00:01.777621*:B60FA0FD:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024D5C718 2025-07-23 22:00:01.777621*:B60FA0FE:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024D5C718 curCtx=0x0000000024D58938 xsc->flg4=65792 flags=2 2025-07-23 22:00:01.777621*:B60FA0FF:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024D5C718 2025-07-23 22:00:01.782960 :B60FA10A: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-07-23 22:00:01.783011 :B60FA10D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:jslv.c:9203 2025-07-23 22:00:01.786282 :B60FA137: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-07-23 22:00:02.165678 :B60FA45D: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-07-23 22:00:02.209324 :B60FA465: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-07-23 22:00:02.225016 :B60FA475: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-07-23 22:00:02.282315 :B60FA47D: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-07-23 22:00:02.415558 :B60FA4AD: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-07-23 22:00:02.530459 :B60FA4B5: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-07-23 22:00:02.540773 :B60FA4BD: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-07-23 22:00:02.557049 :B60FA4C5: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-07-23 22:00:02.573079 :B60FA4CD: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-07-23 22:00:02.589540 :B60FA4D5: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-07-23 22:00:02.599560 :B60FA4DD: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-07-23 22:00:02.614994 :B60FA4E5: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-07-23 22:00:02.624913 :B60FA4ED: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-07-23 22:00:02.640930 :B60FA4F5: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-07-23 22:00:02.650940 :B60FA4FD: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-07-23 22:00:02.660745 :B60FA505: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-07-23 22:00:02.676448 :B60FA536: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-07-23 22:00:02.685968 :B60FA53E: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-07-23 22:00:02.702041 :B60FA546: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-07-23 22:00:02.717813 :B60FA54E: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-07-23 22:00:02.733473 :B60FA556: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-07-23 22:00:02.741199 :B60FA55E: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-07-23 22:00:02.757012 :B60FA566: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-07-23 22:00:02.766728 :B60FA56E: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-07-23 22:00:02.782202 :B60FA576: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-07-23 22:00:02.792181 :B60FA57E: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-07-23 22:00:02.801376 :B60FA586: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-07-23 22:00:02.810731 :B60FA58E: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-07-23 22:00:02.826465 :B60FA596: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-07-23 22:00:02.841973 :B60FA59E: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-07-23 22:00:02.851104 :B60FA5A6: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-07-23 22:00:02.867043 :B60FA5AE: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-07-23 22:00:02.882707 :B60FA5B6: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-07-23 22:00:02.892505 :B60FA5BE: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-07-23 22:00:02.907695 :B60FA5C6: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-07-23 22:00:02.923357 :B60FA5CE: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-07-23 22:00:02.933344 :B60FA5D6: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-07-23 22:00:02.942641 :B60FA5DE: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-07-23 22:00:02.957814 :B60FA5E6: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-07-23 22:00:02.967982 :B60FA5EE: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-07-23 22:00:02.980129 :B60FA5F6: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-07-23 22:00:02.989613 :B60FA5FE: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-07-23 22:00:02.998874 :B60FA606: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-07-23 22:00:03.008102 :B60FA60E: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-07-23 22:00:03.010807*:B60FA620:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000005179FCB8 estart=1753279202 eid=16802794 ctx=0x0000000783637648 cwh=0x0000000027148688 cpu=15625 buffg=478 interb=0 r=0 rb=0 w=0 wb=0 2025-07-23 22:00:03.010807*:B60FA621:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000005179FCB8 curCtx=0x000000005177FEB8 pubTabIdxCnt=0 2025-07-23 22:00:03.010807*:B60FA622:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000005179FCB8 2025-07-23 22:00:03.010807*:B60FA623:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000005179FCB8 2025-07-23 22:00:03.010807*:B60FA624:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024D5C288 estart=1753279201 eid=16777337 ctx=0x000000079F654AA8 cwh=0x0000000024D50158 cpu=1234375 buffg=84170 interb=22822912 r=1116 rb=20529152 w=12 wb=2293760 2025-07-23 22:00:03.010807*:B60FA625:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024D5C288 curCtx=0x000000005177EFE0 pubTabIdxCnt=0 2025-07-23 22:00:03.010807*:B60FA626:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024D5C288 2025-07-23 22:00:03.010807*:B60FA627:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024D5C288 2025-07-23 22:00:03.010807*:B60FA628:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000005179FCB8 curCtx=0x000000005177FEB8 xsc->flg4=65792 flags=0 2025-07-23 22:00:03.010807*:B60FA629:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000005179FCB8 2025-07-23 22:00:03.023683 :B60FA62A: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-07-23 22:00:03.031151 :B60FA632: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-07-23 22:00:03.038642 :B60FA63A: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-07-23 22:00:03.046055 :B60FA65D: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-07-23 22:00:03.053459 :B60FA665: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-07-23 22:00:03.061096 :B60FA678: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-07-23 22:00:03.068473 :B60FA680: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-07-23 22:00:03.076112 :B60FA6A1: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-07-23 22:00:03.083960 :B60FA6A9: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-07-23 22:00:03.091591 :B60FA6B1: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-07-23 22:00:03.099125 :B60FA6B9: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-07-23 22:00:03.106595 :B60FA6C1: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-07-23 22:00:03.114651 :B60FA6C9:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 1, nex 3 2025-07-23 22:00:03.114659 :B60FA6CA:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00813b2e where: ktspbwh1: ktspfsrch 2025-07-23 22:00:04.247069 :B60FA8DC: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-07-23 22:00:05.010060*:B60FA91A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000518BD918 estart=1753279204 eid=16777223 ctx=0x0000000771EA1CA8 cwh=0x00000000517E2A78 cpu=15625 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-07-23 22:00:05.010060*:B60FA91B:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000518BD918 curCtx=0x00000000517AFF28 pubTabIdxCnt=0 2025-07-23 22:00:05.010060*:B60FA91C:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000518BD918 2025-07-23 22:00:05.010060*:B60FA91D:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000518BD918 2025-07-23 22:00:05.010060*:B60FA91E:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024D5C288 estart=1753279201 eid=16777337 ctx=0x000000079F654AA8 cwh=0x0000000024D50158 cpu=1968750 buffg=113425 interb=32800768 r=1725 rb=30507008 w=12 wb=2293760 2025-07-23 22:00:05.010060*:B60FA91F:sql_mon_query:keswx.c@5747:keswxCurStartPlanMonitoring(begin): xsc=0x0000000024D5C288 qc_sid=0 sid=193 sgrp#=0 sset#=0 sv#=65535 sqlid=6119441367216286794 phv=0 estart=1753279201 eid=16777337 li#=0 chi=0x00000007D7C1D128 2025-07-23 22:00:05.010060*:B60FA920:sql_mon_query:keswx.c@4230:keswxWriteGlobalInfoToStream(): wrote to stream flags=1551 modLen=14 modName=DBMS_SCHEDULERATIONanager.current metric purgean actLen=22 actName=ORA$AT_SQ_SQL_SW_12802esholds userid=0 userLen=3 userName=SYS svcLen=0 svcName=SYS$USERS clidLen=0 clid=(null) progLen=17 progName=ORACLE.EXE (J000) plseoid=0 plsesid=0 plscoid=0 plscsid=0 txtLen=959 txt=DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH T 2025-07-23 22:00:05.010060*:B60FA921:sql_mon_query:keswx.c@2145:keswxAddPlanMonitoring(): nbLines=0 nbVarBytes=1026 sqlid=6119441367216286794 sid=193 execStart=1753279201 execId=16777337 2025-07-23 22:00:05.010060*:B60FA922:sql_mon_query:keswx.c@1824:keswxAllocatePlanMemChunk(): add mem chunk to variable stream data=0x00000007DB658B20 buffer=0x00000007DB658B38 size=1632 prev=0x0000000000000000 sizeVarMem=1632 2025-07-23 22:00:05.010060*:B60FA923:sql_mon_query:keswx.c@2353:keswxAddPlanMonitoring(): planEntry=0x00000007DB658A00 added (nbEntries=21 limitEntries=640 nbPlanLines=0 nbLinesLimit=38400) 2025-07-23 22:00:05.010060*:B60FA924:kghsc:kghsc.c@1366:kghscCopyStream(): copy src=0x0000000024D113E8 dst=0x0000000024D10FA0 srcOffset=1026 2025-07-23 22:00:05.010060*:B60FA925:kghsc:kghsc.c@1128:kghscDump(begin): Dumping stream dest (@=0x0000000024D10FA0 offset=0 length=0 size=1632 first=0x00000007DB658B20 cur=0x00000007DB658B20 mbs=1000 hp=0x0000000000000000 opt=18) 2025-07-23 22:00:05.010060*:B60FA926:kghsc:kghsc.c@1147:kghscDump(end): End of dump of compact stream=0x0000000024D10FA0 2025-07-23 22:00:05.010060*:B60FA927:kghsc:kghsc.c@1128:kghscDump(begin): Dumping stream src (@=0x0000000024D113E8 offset=0 length=1026 size=2000 first=0x0000000024D11818 cur=0x0000000024D11818 mbs=1000 hp=0x0000000050BA06D8 opt=57) 2025-07-23 22:00:05.010060*:B60FA928:kghsc:kghsc.c@1147:kghscDump(end): End of dump of compact stream=0x0000000024D113E8 2025-07-23 22:00:05.010060*:B60FA929:kghsc:kghsc.c@1393:kghscCopyStream(): read 1000 bytes from source stream (magic=189) 2025-07-23 22:00:05.010060*:B60FA92A:kghsc:kghsc.c@1393:kghscCopyStream(): read 26 bytes from source stream (magic=189) 2025-07-23 22:00:05.010060*:B60FA92B:kghsc:kghsc.c@1393:kghscCopyStream(): read 0 bytes from source stream (magic=189) 2025-07-23 22:00:05.010060*:B60FA92C:sql_mon_query:keswx.c@3920:keswxCurSetupPublish(): setup completed xsc=0x0000000024D5C288 curCtx=0x000000005177EFE0 pubTabIdxCnt=0 2025-07-23 22:00:05.010060*:B60FA92D:sql_mon_query:keswx.c@5908:keswxCurStartPlanMonitoring(): start monitoring for xsc=0x0000000024D5C288 2025-07-23 22:00:05.010060*:B60FA92E:sql_mon_query:keswx.c@3020:keswxCurPushPlanMonitoring(begin): xsc=0x0000000024D5C288 ctx=0x000000079F654AA8 li#=0 pe=0x00000007DB658A00 incarnation=21 2025-07-23 22:00:05.010060*:B60FA92F:sql_mon_query:keswx.c@3248:keswxCurPushPlanMonitoring(end): xsc=0x0000000024D5C288 dis_mon=0 2025-07-23 22:00:05.010060*:B60FA930:sql_mon_query:keswx.c@5937:keswxCurStartPlanMonitoring(end): xsc=0x0000000024D5C288 mon=1 dis=0 2025-07-23 22:00:05.010060*:B60FA931:sql_mon_query:keswx.c@6257:keswxCurPushMonitoring(end): monitoring started for xsc=0x0000000024D5C288 2025-07-23 22:00:05.072560*:B60FA932:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000518BD918 curCtx=0x00000000517AFF28 xsc->flg4=65792 flags=1 2025-07-23 22:00:05.072560*:B60FA933:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000518BD918 2025-07-23 22:00:06.353940*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=1 options=10264 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-07-23 22:00:06.353940*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-23 22:00:06.353940*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-23 22:00:06.353940*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 0 and execution count: 0 2025-07-23 22:00:06.353940*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980 2025-07-23 22:00:06.353940*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-23 22:00:06.353940*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-23 22:00:06.353940*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=5 options=532496 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-07-23 22:00:06.353940*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-23 22:00:06.353940*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-23 22:00:06.369573*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 0 and execution count: 0 2025-07-23 22:00:06.369573*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980 2025-07-23 22:00:06.369573*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-23 22:00:06.369573*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-23 22:00:06.399315 :B60FAA7D: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-07-23 22:00:06.399641 :B60FAA85: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-07-23 22:00:06.407579 :B60FAA8D: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-07-23 22:00:06.415250 :B60FAA95: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-07-23 22:00:06.422944 :B60FAA9D: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-07-23 22:00:06.431529 :B60FAAA5: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-07-23 22:00:06.431861 :B60FAAAD: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-07-23 22:00:06.431861*:B60FAAB0:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024D5C288 estart=1753279201 eid=16777337 ctx=0x000000079F654AA8 cwh=0x0000000024D50158 cpu=1390625 buffg=224463 interb=1966080 r=121 rb=1966080 w=0 wb=0 2025-07-23 22:00:06.431861*:B60FAAB6:sql_mon_query:keswx.c@6147:keswxCurPushMonitoring(): monitoring already started for xsc=0x0000000024D5C288 2025-07-23 22:00:06.431861*:B60FAAB7:sql_mon_query:keswx.c@3020:keswxCurPushPlanMonitoring(begin): xsc=0x0000000024D5C288 ctx=0x000000079F654AA8 li#=0 pe=0x00000007DB658A00 incarnation=21 2025-07-23 22:00:06.431861*:B60FAAB8:sql_mon_query:keswx.c@3248:keswxCurPushPlanMonitoring(end): xsc=0x0000000024D5C288 dis_mon=0 2025-07-23 22:00:06.431861*:B60FAAB9:sql_mon_query:keswx.c@6257:keswxCurPushMonitoring(end): monitoring started for xsc=0x0000000024D5C288 2025-07-23 22:00:06.431861*:B60FAABA:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024D5C288 curCtx=0x000000005177EFE0 xsc->flg4=67840 flags=2 2025-07-23 22:00:06.431861*:B60FAABB:sql_mon_query:keswx.c@3020:keswxCurPushPlanMonitoring(begin): xsc=0x0000000024D5C288 ctx=0x000000079F654AA8 li#=0 pe=0x00000007DB658A00 incarnation=21 2025-07-23 22:00:06.431861*:B60FAABC:sql_mon_query:keswx.c@3248:keswxCurPushPlanMonitoring(end): xsc=0x0000000024D5C288 dis_mon=0 2025-07-23 22:00:06.431861*:B60FAABD:sql_mon_query:keswx.c@3484:keswxWriteEndInfoToStream(begin): xsc=0x0000000024D5C288 curCtx=0x000000005177EFE0 endFlags=2 pxSlaveCursor=0 2025-07-23 22:00:06.431861*:B60FAABE:sql_mon_query:keswx.c@3681:keswxWriteEndInfoToStream(end): done2025-07-23 22:00:06.431861*:B60FAABF:sql_mon_query:keswx.c@3376:keswxCurEndPlanMonitoringCb(): switching state for xsc=0x0000000024D5C288 pe=0x00000007DB658A00 endflag=2 flags=1 state=5 2025-07-23 22:00:06.431861*:B60FAAC0:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024D5C288 2025-07-23 22:00:06.432191 :B60FAAC1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:jslv.c:9203 2025-07-23 22:00:06.436947 :B60FAAC2: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-07-23 22:00:06.437026 :B60FAAC5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-07-23 22:00:06.437116 :B60FAAD2: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 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 24 (osid: 9372, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de