Flame Graph: SLOB logical IO - filtered
kafger (166 samples, 0.03%)
kksLockDelete (52 samples, 0.01%)
INDEX: Start (1,367 samples, 0.25%)
ktagetp_internal (52 samples, 0.01%)
kcbzar (107 samples, 0.02%)
ktrget3 (617 samples, 0.11%)
kglPinSetContext (107 samples, 0.02%)
kksumc (3,900 samples, 0.70%)
kpobii (1,129 samples, 0.20%)
kxsReleaseRuntimeLock (1,445 samples, 0.26%)
kcbrab (122 samples, 0.02%)
kghufree (184 samples, 0.03%)
kghalp (502 samples, 0.09%)
kcbgtcr (1,975 samples, 0.35%)
kghalp (621 samples, 0.11%)
kdxbrs1 (601 samples, 0.11%)
GROUP BY SORT: Fetch (496,720 samples, 89.03%)
GROUP BY SORT: Fetch
kcbrls (402 samples, 0.07%)
ktiTxnPoolFree (323 samples, 0.06%)
kcbz_fp_buf (54 samples, 0.01%)
kdxlrs2 (1,259 samples, 0.23%)
kglpnp (60 samples, 0.01%)
kpobav (1,286 samples, 0.23%)
kcbzgsf (55 samples, 0.01%)
kghfrf (165 samples, 0.03%)
kscdnfy (111 samples, 0.02%)
kghfrh (172 samples, 0.03%)
kcbcge (97 samples, 0.02%)
kcsmban (57 samples, 0.01%)
ksugitp_i (216 samples, 0.04%)
ksxcmr (62 samples, 0.01%)
kksGetStats (126 samples, 0.02%)
kghalf (125 samples, 0.02%)
kghfrh_internal (155 samples, 0.03%)
kxsSsaUpdateAllssa (63 samples, 0.01%)
kksLockAllocate (112 samples, 0.02%)
kcbz_fp_buf (325 samples, 0.06%)
kghpmfal (48 samples, 0.01%)
kghualloc (234 samples, 0.04%)
INDEX: tFetch (234 samples, 0.04%)
kdichkstop (1,238 samples, 0.22%)
kdifxs (15,965 samples, 2.86%)
kd..
kcbz_find_bpid (104 samples, 0.02%)
kghssgai (826 samples, 0.15%)
INDEX: GetRowid (1,436 samples, 0.26%)
kcbispnd (2,410 samples, 0.43%)
ktiNonImuPoolAllocate (252 samples, 0.05%)
kghalo (367 samples, 0.07%)
kgscReleaseACursor (1,294 samples, 0.23%)
kcbzar (199 samples, 0.04%)
kssdch (74 samples, 0.01%)
ktifspt (62 samples, 0.01%)
kohalc (448 samples, 0.08%)
kgxDecrementExamine (112 samples, 0.02%)
kdifxs (171 samples, 0.03%)
ktcdso (1,855 samples, 0.33%)
kghfrmrg (178 samples, 0.03%)
kcbipnns (62 samples, 0.01%)
krtr2a (197 samples, 0.04%)
kksCloseCursor (536 samples, 0.10%)
kslfre (153 samples, 0.03%)
kghfre (55 samples, 0.01%)
ktcSetFromGlobalSnapshot (53 samples, 0.01%)
kglHandleInvalidations (68 samples, 0.01%)
kssrmf_numa_intl (175 samples, 0.03%)
kghpir (49 samples, 0.01%)
kcbzgsf (160 samples, 0.03%)
kkxexe (555,711 samples, 99.60%)
kkxexe
kcbzar (12,078 samples, 2.16%)
k..
kssadf_numa_intl (163 samples, 0.03%)
kglHandleLoads (66 samples, 0.01%)
kews_sqlcol_begin (249 samples, 0.04%)
ktcgxg (53 samples, 0.01%)
FILTER DEFINITION: Fetch (494,854 samples, 88.69%)
FILTER DEFINITION: Fetch
kcbpflmt (54 samples, 0.01%)
kksCancelCursor (133 samples, 0.02%)
kgiPinObject (62 samples, 0.01%)
kdsgrp (320,087 samples, 57.37%)
kdsgrp
kssdel (975 samples, 0.17%)
kssrmf_numa_intl (48 samples, 0.01%)
kcbsacc (104 samples, 0.02%)
INDEX: Init_kdixs (76 samples, 0.01%)
INDEX: tFetch (30,960 samples, 5.55%)
INDEX: ..
kdk4cml (181 samples, 0.03%)
kdkmak (52 samples, 0.01%)
kjxgndel (67 samples, 0.01%)
kspgip (96 samples, 0.02%)
kksxsccompat2_static_sql (58 samples, 0.01%)
kghprmalo (334 samples, 0.06%)
kghufreetop (64 samples, 0.01%)
kcbrls (223 samples, 0.04%)
SELECT FETCH: (506,491 samples, 90.78%)
SELECT FETCH:
kjuxdel (54 samples, 0.01%)
kghfrf (56 samples, 0.01%)
kcbs_simulate (38,217 samples, 6.85%)
kcbs_simu..
kcbgtcr (2,889 samples, 0.52%)
kglpnp (174 samples, 0.03%)
kdkcmp1 (73 samples, 0.01%)
ktagetp_internal (54 samples, 0.01%)
kdifkc (733 samples, 0.13%)
kghalo (94 samples, 0.02%)
kews_sqlcol_end (227 samples, 0.04%)
kews_pls_jvm_event_suspend_i (57 samples, 0.01%)
kcbgtcr (238,318 samples, 42.71%)
kcbgtcr
kxccrctx (86 samples, 0.02%)
kcbzgsf (64 samples, 0.01%)
ktrexc (1,103 samples, 0.20%)
ktrgcm (94 samples, 0.02%)
kcbipnns (815 samples, 0.15%)
ksudlc (729 samples, 0.13%)
kghalf (81 samples, 0.01%)
kcbrls (45,390 samples, 8.14%)
kcbrls
kghalf (1,039 samples, 0.19%)
ktrgcm (25,516 samples, 4.57%)
ktrgcm
kksMapCursor (70 samples, 0.01%)
QUERY EXECUTION PREFETCH: Start (48 samples, 0.01%)
kpoal8 (555,711 samples, 99.60%)
kpoal8
kghssgai (60 samples, 0.01%)
kjxgndel (140 samples, 0.03%)
TABLE ACCESS: GetPartitionNumber (158 samples, 0.03%)
ktrget2 (2,738 samples, 0.49%)
ktrget2 (283,522 samples, 50.82%)
ktrget2
ktsmg_max_query (130 samples, 0.02%)
kcscur3 (49 samples, 0.01%)
kghfrmrg (60 samples, 0.01%)
kews_sqlcol_begin (80 samples, 0.01%)
ktcspGrabInternalSavepoint (163 samples, 0.03%)
kcbzfs (7,043 samples, 1.26%)
kksCompareKxscAuthenv (72 samples, 0.01%)
kxsFreeExecutionHeap (1,346 samples, 0.24%)
TABLE ACCESS: FetchByRowID (49 samples, 0.01%)
kksumc (92 samples, 0.02%)
kticpru (77 samples, 0.01%)
kxsInitExecutionHeap (105 samples, 0.02%)
kcscur3 (53 samples, 0.01%)
kksLockDelete (1,355 samples, 0.24%)
kdifxs1 (55 samples, 0.01%)
kafger (168 samples, 0.03%)
kscdnfy (49 samples, 0.01%)
kgscGetCursor (466 samples, 0.08%)
kcbz_fp_buf (211 samples, 0.04%)
kghfrh (557 samples, 0.10%)
kghalo (129 samples, 0.02%)
kghalp (246 samples, 0.04%)
kghfnd (68 samples, 0.01%)
kglLockExecutions (52 samples, 0.01%)
kdixses_end_scan (174 samples, 0.03%)
QUERY EXECUTION PREFETCH: Close (641 samples, 0.11%)
kokegGetGCTable (62 samples, 0.01%)
kcbzgsf (254 samples, 0.05%)
kksfbc (2,893 samples, 0.52%)
kcbcge (2,009 samples, 0.36%)
kcbzar (56 samples, 0.01%)
kgscIsCursorOpen (101 samples, 0.02%)
kksMapCursor (907 samples, 0.16%)
kghfnd (304 samples, 0.05%)
kghbshrt (78 samples, 0.01%)
kcbzfs (76 samples, 0.01%)
ksupop (2,076 samples, 0.37%)
kkocsCheckBindAware (48 samples, 0.01%)
QUERY EXECUTION PREFETCH: Init (1,331 samples, 0.24%)
kkocsACSSaveStats (111 samples, 0.02%)
ktcckv (140 samples, 0.03%)
kdsgrp (165 samples, 0.03%)
kghfnd (109 samples, 0.02%)
kxsSsaSetSqlid (329 samples, 0.06%)
ktrexf (1,382 samples, 0.25%)
ksugit_i (190 samples, 0.03%)
TABLE ACCESS: Start (3,314 samples, 0.59%)
kocend (419 samples, 0.08%)
kjuxdel (446 samples, 0.08%)
knasiddl (51 samples, 0.01%)
kghaddex (113 samples, 0.02%)
kcsgssn (113 samples, 0.02%)
kcbs_simulate (118 samples, 0.02%)
GROUP BY SORT: Close (1,419 samples, 0.25%)
ksugitp_i (153 samples, 0.03%)
kcbgtcr (623 samples, 0.11%)
kcbrls (116 samples, 0.02%)
kskmkinact (127 samples, 0.02%)
kcbispnd (128 samples, 0.02%)
ktiTxnPoolAllocate (341 samples, 0.06%)
QUERY EXECUTION PREFETCH: Fetch (32,521 samples, 5.83%)
QUERY E..
kglLockExecutions (54 samples, 0.01%)
kprccu (717 samples, 0.13%)
kghgex (205 samples, 0.04%)
kokbcln (48 samples, 0.01%)
QUERY EXECUTION PREFETCH: Start (3,068 samples, 0.55%)
TABLE ACCESS: FetchByRowID (493,838 samples, 88.51%)
TABLE ACCESS: FetchByRowID
kssadf_numa_intl (89 samples, 0.02%)
kdxlrs2 (729 samples, 0.13%)
TABLE ACCESS: GetPartitionNumber (1,306 samples, 0.23%)
kghupr_flg (1,055 samples, 0.19%)
kxsmbb (1,172 samples, 0.21%)
ktiNonImuPoolFree (232 samples, 0.04%)
kcbz_fp_buf (134 samples, 0.02%)
kcbzgsf (9,153 samples, 1.64%)
ktucss (508 samples, 0.09%)
kxsFreeExecutionHeap (53 samples, 0.01%)
kprcdt (459 samples, 0.08%)
kcbz_fp_buf (47,153 samples, 8.45%)
kcbz_fp_buf
kksasatt (62 samples, 0.01%)
kghfre (272 samples, 0.05%)
kggslCount (53 samples, 0.01%)
ktaadm (90 samples, 0.02%)
FILTER DEFINITION: Rop (179 samples, 0.03%)
kxsFastCloseCursor (994 samples, 0.18%)
kghrst (148 samples, 0.03%)
kghfnd (163 samples, 0.03%)
kcbispnd (467 samples, 0.08%)
kslfre (4,827 samples, 0.87%)
kcbsacc (90 samples, 0.02%)
kcbpflmt (646 samples, 0.12%)
kdkcml (194 samples, 0.03%)
INDEX: GetKey (489 samples, 0.09%)
INDEX: ChangePartition_kdixs (75 samples, 0.01%)
kghgex (155 samples, 0.03%)
kpobsv (807 samples, 0.14%)
ktcAllocXcb (2,106 samples, 0.38%)
kjunid (70 samples, 0.01%)
kcbs_simulate (204 samples, 0.04%)
kspges (116 samples, 0.02%)
ktsmg_max_query (242 samples, 0.04%)
kxsOpenACursor (57 samples, 0.01%)
ksusrs_i (72 samples, 0.01%)
ktrgtc2 (3,226 samples, 0.58%)
kskmkinact (190 samples, 0.03%)
kcbz_fp_buf (350 samples, 0.06%)
kcbsacc (30,822 samples, 5.52%)
kcbsacc
ktpqod (609 samples, 0.11%)
kglrtg (204 samples, 0.04%)
ktrexf (162 samples, 0.03%)
kcbrls (131 samples, 0.02%)
kcbipnns (53 samples, 0.01%)
kghxhal (58 samples, 0.01%)
ktrget3 (2,652 samples, 0.48%)
kprccu (387 samples, 0.07%)
kghprmalo (179 samples, 0.03%)
ktrgcm (364 samples, 0.07%)
ktcIDLFlushCtxs (52 samples, 0.01%)
kcbs_simulate (55 samples, 0.01%)
kafger (37,341 samples, 6.69%)
kafger
ktcckv (130 samples, 0.02%)
kcbsacc (113 samples, 0.02%)
kclral (50 samples, 0.01%)
kohfrr (66 samples, 0.01%)
QUERY EXECUTION PREFETCH: Fetch (205 samples, 0.04%)
ksfflt (164 samples, 0.03%)
kdifxs1 (127 samples, 0.02%)
kcbgtcr (531 samples, 0.10%)
ktrget3 (108 samples, 0.02%)
koctxed (326 samples, 0.06%)
kdifkc (1,401 samples, 0.25%)
ksfglt (269 samples, 0.05%)
GROUP BY SORT: Fetch (63 samples, 0.01%)
kcbgtcr (137 samples, 0.02%)
kcbzfs (192 samples, 0.03%)
kssdch (84 samples, 0.02%)
kghfrh_internal (550 samples, 0.10%)
ksuprc (1,016 samples, 0.18%)
kocbeg (605 samples, 0.11%)
kslgetl (924 samples, 0.17%)
ktrget2 (127 samples, 0.02%)
kdk4cml (71 samples, 0.01%)
kssadf_numa_intl (135 samples, 0.02%)
kprcdt (105 samples, 0.02%)
ktiFlushTopTxn (108 samples, 0.02%)
ksugit_i (247 samples, 0.04%)
FILTER DEFINITION: Start (4,127 samples, 0.74%)
kxsFastOpenCursor (122 samples, 0.02%)
kxsxsi (3,278 samples, 0.59%)
kghgex (186 samples, 0.03%)
all (557,944 samples, 100%)
kxsfbb (217 samples, 0.04%)
ktrget3 (281,278 samples, 50.41%)
ktrget3
kslfre (2,003 samples, 0.36%)
kdifxs (298 samples, 0.05%)
ktucss (3,067 samples, 0.55%)
kzasad (49 samples, 0.01%)
FILTER DEFINITION: Rop (2,797 samples, 0.50%)
GROUP BY SORT: Start (5,798 samples, 1.04%)
ktrgcm (72 samples, 0.01%)
kcb_check_private_pins (59 samples, 0.01%)
kxsSsaUpdateAllssa (429 samples, 0.08%)
kghtshrt (88 samples, 0.02%)
kslfre (52 samples, 0.01%)
kghfrmrg (48 samples, 0.01%)
kksdip (53 samples, 0.01%)
kssmov (110 samples, 0.02%)
ktrget2 (621 samples, 0.11%)
kssadf_numa_intl (4,159 samples, 0.75%)
ktrget3 (61 samples, 0.01%)
kgiPinObject (563 samples, 0.10%)
ktsmg_max_query (767 samples, 0.14%)
kohfrr (267 samples, 0.05%)
kghfrh (157 samples, 0.03%)
kews_sqlcol_end (280 samples, 0.05%)
kghgex (711 samples, 0.13%)
INDEX: GetRowid (50 samples, 0.01%)
ksudlc (88 samples, 0.02%)
QUERY EXECUTION PREFETCH: Beneficial (1,003 samples, 0.18%)
ktcCommitTxn (2,634 samples, 0.47%)
kxsFreeWorkArea (894 samples, 0.16%)
kslgetl (138 samples, 0.02%)
kdifxs1 (15,892 samples, 2.85%)
kd..
kgxAOLInit (98 samples, 0.02%)
kohalmc (341 samples, 0.06%)
kghfrh_internal (135 samples, 0.02%)
TABLE ACCESS: Close (1,227 samples, 0.22%)
ktcsna (325 samples, 0.06%)
kghfnd (229 samples, 0.04%)
ksu_validate_session (143 samples, 0.03%)
kdifxs_stopkey_hit (112 samples, 0.02%)
kghprmalo (440 samples, 0.08%)
kksGetStats (65 samples, 0.01%)
kxsGetRuntimeLock (644 samples, 0.12%)
kssrmf_numa_intl (4,464 samples, 0.80%)
kglsim_pin_simhp (135 samples, 0.02%)
kxsSsaClearSession (203 samples, 0.04%)
kglsim_per_granule_hit (132 samples, 0.02%)
INDEX: Close (592 samples, 0.11%)
kghalo (117 samples, 0.02%)
kcbgtcr (83 samples, 0.01%)
INDEX: ReInit_kdixs (137 samples, 0.02%)
ksslct (64 samples, 0.01%)
ksuvrl (518 samples, 0.09%)
kslgetl (672 samples, 0.12%)
kksIsCursorSessionCacheable (151 samples, 0.03%)