Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250728220008\orcl_j004_19412_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250728220008\orcl_j004_19412_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:35900M/63366M, Ph+PgF:41621M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 30 Windows thread id: 19412, image: ORACLE.EXE (J004) *** 2025-07-28 22:00:09.049 *** SESSION ID:(241.3499) 2025-07-28 22:00:09.049 *** 2025-07-28 22:00:09.049 Process diagnostic dump for ORACLE.EXE (J004), OS id=19412, pid: 30, proc_ser: 110, sid: 241, sess_ser: 3499 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 19412 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J004) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.222423 sec, exc=0.222423 sec, total=0.222423 sec wait times: max=0.500000 sec, heur=0.222423 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.000000 sec since current wait Sampled Session History of session 241 serial 3499 --------------------------------------------------- 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 --------------------------------------------------- [1 sample, 22:00:09] idle wait at each sample [session created at: 22:00:08] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-28 22:00:09.049 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 30 (osid: 19412, J004) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-28 22:00:02.056687 :B8465752:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpus:jslv.c:9203 2025-07-28 22:00:02.060682 :B84658D2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.447129 :B84659E1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.491143 :B84659E9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.506716 :B84659F1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.563846 :B84659F9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.695783 :B8465A09:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.809645 :B8465A1D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.819547 :B8465A25:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.835289 :B8465A3A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.851019 :B8465A42:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.867409 :B8465A4A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.877233 :B8465A52:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.887324 :B8465A5A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.903065 :B8465A62:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.919171 :B8465A6A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.929290 :B8465A72:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.939248 :B8465A7A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.954801 :B8465A82:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.964221 :B8465A8A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.980560 :B8465A92:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:02.996581 :B8465A9A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.012345 :B8465AA2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.027863 :B8465AAA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.034996 :B8465AB2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.044762 :B8465ABA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.060508 :B8465AC2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.070129 :B8465ACA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.080301 :B8465AD2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.096204 :B8465ADA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.105673 :B8465AE2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.115545 :B8465AEA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.131536 :B8465AF2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.138936 :B8465AFA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.148923 :B8465B02:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.165074 :B8465B0A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.181140 :B8465B12:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.191354 :B8465B1A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.207653 :B8465B22:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.223222 :B8465B52:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.238731 :B8465B5A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.249005 :B8465B62:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.261426 :B8465B75:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.271109 :B8465B7D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.280383 :B8465B85:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.290326 :B8465B8D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.305982 :B8465B95:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.315720 :B8465B9D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.325085 :B8465BA5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.332523 :B8465BAD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.340345 :B8465BB5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.348157 :B8465BBD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.355527 :B8465BC5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.362877 :B8465BCD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.370755 :B8465BD5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.378559 :B8465BDD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.386265 :B8465BE5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.393808 :B8465BED:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.402426 :B8465BF5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.406905*:B8465C07:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000052E9A188 estart=1753711202 eid=16803869 ctx=0x0000000783637648 cwh=0x00000000341F0068 cpu=15625 buffg=139 interb=0 r=0 rb=0 w=0 wb=0 2025-07-28 22:00:03.406905*:B8465C08:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000052E9A188 curCtx=0x0000000052F0EED8 pubTabIdxCnt=0 2025-07-28 22:00:03.406905*:B8465C09:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000052E9A188 2025-07-28 22:00:03.406905*:B8465C0A:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000052E9A188 2025-07-28 22:00:03.406905*:B8465C0B:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002DC3C288 estart=1753711201 eid=16777342 ctx=0x000000079F654AA8 cwh=0x000000002DC30158 cpu=1328125 buffg=87761 interb=29016064 r=1494 rb=26722304 w=12 wb=2293760 2025-07-28 22:00:03.406905*:B8465C0C:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002DC3C288 curCtx=0x0000000052F0E000 pubTabIdxCnt=0 2025-07-28 22:00:03.406905*:B8465C0D:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002DC3C288 2025-07-28 22:00:03.406905*:B8465C0E:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002DC3C288 2025-07-28 22:00:03.410388 :B8465C0F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:03.410388*:B8465C17:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000052E9A188 curCtx=0x0000000052F0EED8 xsc->flg4=65792 flags=0 2025-07-28 22:00:03.410388*:B8465C18:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000052E9A188 2025-07-28 22:00:04.529991 :B8465DFD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:04.532398 :B8465E05:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:04.532633 :B8465E0D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:04.540367 :B8465E15:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:04.547955 :B8465E1D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:04.555465 :B8465E25:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:04.564065 :B8465E2D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:05.407931*:B8465EC4:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002DC375F8 estart=1753711204 eid=16777220 ctx=0x0000000779774C28 cwh=0x00000000341707E8 cpu=93750 buffg=3457 interb=0 r=0 rb=0 w=0 wb=0 2025-07-28 22:00:05.407931*:B8465EC5:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002DC375F8 curCtx=0x0000000052F3CBC0 pubTabIdxCnt=0 2025-07-28 22:00:05.407931*:B8465EC6:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002DC375F8 2025-07-28 22:00:05.407931*:B8465EC7:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002DC375F8 2025-07-28 22:00:05.407931*:B8465EC8:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002DC3C288 estart=1753711201 eid=16777342 ctx=0x000000079F654AA8 cwh=0x000000002DC30158 cpu=1906250 buffg=107634 interb=27525120 r=1403 rb=25231360 w=12 wb=2293760 2025-07-28 22:00:05.407931*:B8465EC9:sql_mon_query:keswx.c@5747:keswxCurStartPlanMonitoring(begin): xsc=0x000000002DC3C288 qc_sid=0 sid=241 sgrp#=0 sset#=0 sv#=65535 sqlid=6119441367216286794 phv=0 estart=1753711201 eid=16777342 li#=0 chi=0x00000007D7C1D128 2025-07-28 22:00:05.407931*:B8465ECA:sql_mon_query:keswx.c@4230:keswxWriteGlobalInfoToStream(): wrote to stream flags=1551 modLen=14 modName=DBMS_SCHEDULERexeONanager.current metric purgean actLen=22 actName=ORA$AT_SQ_SQL_SW_12833nsholds userid=0 userLen=3 userName=SYS svcLen=0 svcName=SYS$USERS clidLen=0 clid=(null) progLen=17 progName=ORACLE.EXE (J004) 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-28 22:00:05.407931*:B8465ECB:sql_mon_query:keswx.c@2145:keswxAddPlanMonitoring(): nbLines=0 nbVarBytes=1026 sqlid=6119441367216286794 sid=241 execStart=1753711201 execId=16777342 2025-07-28 22:00:05.407931*:B8465ECC:sql_mon_query:keswx.c@1824:keswxAllocatePlanMemChunk(): add mem chunk to variable stream data=0x00000007DB57EEA8 buffer=0x00000007DB57EEC0 size=1632 prev=0x0000000000000000 sizeVarMem=1632 2025-07-28 22:00:05.407931*:B8465ECD:sql_mon_query:keswx.c@2353:keswxAddPlanMonitoring(): planEntry=0x00000007DB57ED88 added (nbEntries=23 limitEntries=640 nbPlanLines=0 nbLinesLimit=38400) 2025-07-28 22:00:05.407931*:B8465ECE:kghsc:kghsc.c@1366:kghscCopyStream(): copy src=0x00000000325821E8 dst=0x0000000032581DA0 srcOffset=1026 2025-07-28 22:00:05.407931*:B8465ECF:kghsc:kghsc.c@1128:kghscDump(begin): Dumping stream dest (@=0x0000000032581DA0 offset=0 length=0 size=1632 first=0x00000007DB57EEA8 cur=0x00000007DB57EEA8 mbs=1000 hp=0x0000000000000000 opt=18) 2025-07-28 22:00:05.407931*:B8465ED0:kghsc:kghsc.c@1147:kghscDump(end): End of dump of compact stream=0x0000000032581DA0 2025-07-28 22:00:05.407931*:B8465ED1:kghsc:kghsc.c@1128:kghscDump(begin): Dumping stream src (@=0x00000000325821E8 offset=0 length=1026 size=2000 first=0x0000000032582618 cur=0x0000000032582618 mbs=1000 hp=0x0000000051B96E48 opt=57) 2025-07-28 22:00:05.407931*:B8465ED2:kghsc:kghsc.c@1147:kghscDump(end): End of dump of compact stream=0x00000000325821E8 2025-07-28 22:00:05.407931*:B8465ED3:kghsc:kghsc.c@1393:kghscCopyStream(): read 1000 bytes from source stream (magic=189) 2025-07-28 22:00:05.407931*:B8465ED4:kghsc:kghsc.c@1393:kghscCopyStream(): read 26 bytes from source stream (magic=189) 2025-07-28 22:00:05.407931*:B8465ED5:kghsc:kghsc.c@1393:kghscCopyStream(): read 0 bytes from source stream (magic=189) 2025-07-28 22:00:05.407931*:B8465ED6:sql_mon_query:keswx.c@3920:keswxCurSetupPublish(): setup completed xsc=0x000000002DC3C288 curCtx=0x0000000052F0E000 pubTabIdxCnt=0 2025-07-28 22:00:05.407931*:B8465ED7:sql_mon_query:keswx.c@5908:keswxCurStartPlanMonitoring(): start monitoring for xsc=0x000000002DC3C288 2025-07-28 22:00:05.407931*:B8465ED8:sql_mon_query:keswx.c@3020:keswxCurPushPlanMonitoring(begin): xsc=0x000000002DC3C288 ctx=0x000000079F654AA8 li#=0 pe=0x00000007DB57ED88 incarnation=23 2025-07-28 22:00:05.407931*:B8465ED9:sql_mon_query:keswx.c@3248:keswxCurPushPlanMonitoring(end): xsc=0x000000002DC3C288 dis_mon=0 2025-07-28 22:00:05.407931*:B8465EDA:sql_mon_query:keswx.c@5937:keswxCurStartPlanMonitoring(end): xsc=0x000000002DC3C288 mon=1 dis=0 2025-07-28 22:00:05.407931*:B8465EDB:sql_mon_query:keswx.c@6257:keswxCurPushMonitoring(end): monitoring started for xsc=0x000000002DC3C288 2025-07-28 22:00:05.423554*:B8465EDC:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002DC375F8 curCtx=0x0000000052F3CBC0 xsc->flg4=65792 flags=1 2025-07-28 22:00:05.423554*:B8465EDD:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002DC375F8 2025-07-28 22:00:06.970453*: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-28 22:00:06.970453*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-28 22:00:06.970453*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-28 22:00:06.970453*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 0 and execution count: 0 2025-07-28 22:00:06.970453*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980 2025-07-28 22:00:06.970453*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-28 22:00:06.970453*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-28 22:00:06.970453*: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-28 22:00:06.970453*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-28 22:00:06.970453*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-28 22:00:06.986078*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 0 and execution count: 0 2025-07-28 22:00:06.986078*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980 2025-07-28 22:00:06.986078*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-28 22:00:06.986078*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-28 22:00:07.027323 :B8465FDA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:07.027736 :B8465FE2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:07.036617 :B8465FEA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:07.045055 :B8465FF2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:07.053631 :B8465FFA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:07.062057 :B8466002:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:07.070886 :B846600A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:07.407958*:B8466012:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000034171608 estart=1753711206 eid=16777219 ctx=0x00000007762AA500 cwh=0x00000000341B2960 cpu=15625 buffg=258 interb=0 r=0 rb=0 w=0 wb=0 2025-07-28 22:00:07.407958*:B8466013:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000034171608 curCtx=0x0000000052F7D798 pubTabIdxCnt=0 2025-07-28 22:00:07.407958*:B8466014:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000034171608 2025-07-28 22:00:07.407958*:B8466015:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000034171608 2025-07-28 22:00:07.407958*:B8466016:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002DC3C288 estart=1753711201 eid=16777342 ctx=0x000000079F654AA8 cwh=0x000000002DC30158 cpu=1984375 buffg=141826 interb=2424832 r=149 rb=2424832 w=0 wb=0 2025-07-28 22:00:07.407958*:B8466017:sql_mon_query:keswx.c@6147:keswxCurPushMonitoring(): monitoring already started for xsc=0x000000002DC3C288 2025-07-28 22:00:07.407958*:B8466018:sql_mon_query:keswx.c@3020:keswxCurPushPlanMonitoring(begin): xsc=0x000000002DC3C288 ctx=0x000000079F654AA8 li#=0 pe=0x00000007DB57ED88 incarnation=23 2025-07-28 22:00:07.407958*:B8466019:sql_mon_query:keswx.c@3248:keswxCurPushPlanMonitoring(end): xsc=0x000000002DC3C288 dis_mon=0 2025-07-28 22:00:07.407958*:B846601A:sql_mon_query:keswx.c@6257:keswxCurPushMonitoring(end): monitoring started for xsc=0x000000002DC3C288 2025-07-28 22:00:07.439205*:B846601B:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000034171608 curCtx=0x0000000052F7D798 xsc->flg4=65792 flags=1 2025-07-28 22:00:07.439205*:B846601C:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000034171608 2025-07-28 22:00:08.736056*: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-28 22:00:08.736056*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-28 22:00:08.736056*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-28 22:00:08.751688*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 0 and execution count: 0 2025-07-28 22:00:08.751688*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980 2025-07-28 22:00:08.751688*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-28 22:00:08.751688*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-28 22:00:08.751688*: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-28 22:00:08.751688*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-28 22:00:08.751688*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-28 22:00:08.751688*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 0 and execution count: 0 2025-07-28 22:00:08.751688*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980 2025-07-28 22:00:08.751688*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-28 22:00:08.751688*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-28 22:00:08.751688*: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-28 22:00:08.751688*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-28 22:00:08.751688*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-28 22:00:08.767315*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 0 and execution count: 0 2025-07-28 22:00:08.767315*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980 2025-07-28 22:00:08.767315*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-28 22:00:08.767315*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-28 22:00:08.816083 :B846612A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:08.816412 :B8466132:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:08.825498 :B846613A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:08.825851 :B8466142:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:08.825851*:B846614A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002DC3C288 estart=1753711201 eid=16777342 ctx=0x000000079F654AA8 cwh=0x000000002DC30158 cpu=1390625 buffg=133457 interb=704512 r=41 rb=704512 w=0 wb=0 2025-07-28 22:00:08.825851*:B846614B:sql_mon_query:keswx.c@6147:keswxCurPushMonitoring(): monitoring already started for xsc=0x000000002DC3C288 2025-07-28 22:00:08.825851*:B846614C:sql_mon_query:keswx.c@3020:keswxCurPushPlanMonitoring(begin): xsc=0x000000002DC3C288 ctx=0x000000079F654AA8 li#=0 pe=0x00000007DB57ED88 incarnation=23 2025-07-28 22:00:08.825851*:B846614D:sql_mon_query:keswx.c@3248:keswxCurPushPlanMonitoring(end): xsc=0x000000002DC3C288 dis_mon=0 2025-07-28 22:00:08.825851*:B846614E:sql_mon_query:keswx.c@6257:keswxCurPushMonitoring(end): monitoring started for xsc=0x000000002DC3C288 2025-07-28 22:00:08.825851*:B846614F:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002DC3C288 curCtx=0x0000000052F0E000 xsc->flg4=67840 flags=2 2025-07-28 22:00:08.825851*:B8466150:sql_mon_query:keswx.c@3020:keswxCurPushPlanMonitoring(begin): xsc=0x000000002DC3C288 ctx=0x000000079F654AA8 li#=0 pe=0x00000007DB57ED88 incarnation=23 2025-07-28 22:00:08.825851*:B8466151:sql_mon_query:keswx.c@3248:keswxCurPushPlanMonitoring(end): xsc=0x000000002DC3C288 dis_mon=0 2025-07-28 22:00:08.825851*:B8466152:sql_mon_query:keswx.c@3484:keswxWriteEndInfoToStream(begin): xsc=0x000000002DC3C288 curCtx=0x0000000052F0E000 endFlags=2 pxSlaveCursor=0 2025-07-28 22:00:08.825851*:B8466153:sql_mon_query:keswx.c@3681:keswxWriteEndInfoToStream(end): done2025-07-28 22:00:08.825851*:B8466154:sql_mon_query:keswx.c@3376:keswxCurEndPlanMonitoringCb(): switching state for xsc=0x000000002DC3C288 pe=0x00000007DB57ED88 endflag=2 flags=1 state=5 2025-07-28 22:00:08.825851*:B8466155:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002DC3C288 2025-07-28 22:00:08.826178 :B8466156:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpop:jslv.c:9203 2025-07-28 22:00:08.830894 :B8466157:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-28 22:00:08.830985 :B846615A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-07-28 22:00:08.831059 :B8466163:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] 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 30 (osid: 19412, J004)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de