Flame Graph: parsing of select count(*) from dba_source, CBO 11.2.0.4
kkejeq (269 samples, 0.97%)
kksfbc (26,018 samples, 93.61%)
kksfbc
kkepslCompCtl (112 samples, 0.40%)
kkocnp (234 samples, 0.84%)
apakkoqb (340 samples, 1.22%)
kkoqbc (264 samples, 0.95%)
peicnt (26,123 samples, 93.99%)
peicnt
apakkoqb (485 samples, 1.74%)
kketac (500 samples, 1.80%)
qcspqb (1,369 samples, 4.93%)
qcspqb
apaqbdDescendents (492 samples, 1.77%)
qerhjComputeFanoutAndBPS (204 samples, 0.73%)
kkeIdxSelectivity (1,839 samples, 6.62%)
kkeIdxSel..
kkotap (108 samples, 0.39%)
kkocnp (171 samples, 0.62%)
kkepslCompCtl (342 samples, 1.23%)
kkepsl (181 samples, 0.65%)
qcsevw (542 samples, 1.95%)
q..
kkocnp (302 samples, 1.09%)
kkeEqJoinSel (593 samples, 2.13%)
k..
apaqbdDescendents (1,098 samples, 3.95%)
apaq..
kkejeq (181 samples, 0.65%)
kkojnp (129 samples, 0.46%)
kkejeq (114 samples, 0.41%)
kkejcd (163 samples, 0.59%)
kkotap (700 samples, 2.52%)
kk..
kkoiff (158 samples, 0.57%)
kkooqb (1,125 samples, 4.05%)
kkooqb
kkeidc (3,445 samples, 12.39%)
kkeidc
kkeEqJoinSel (450 samples, 1.62%)
qksbgGetVal (120 samples, 0.43%)
pevm_icd_call_common (26,117 samples, 93.97%)
pevm_icd_call_common
kkejcd (109 samples, 0.39%)
kkejeq (271 samples, 0.98%)
kkonxc (4,253 samples, 15.30%)
kkonxc
appget (129 samples, 0.46%)
qkadrv2 (342 samples, 1.23%)
opitca (24,391 samples, 87.76%)
opitca
kkepslCompCtl (106 samples, 0.38%)
opiosq0 (168 samples, 0.60%)
qcpiqex (152 samples, 0.55%)
kkxexe (26,123 samples, 93.99%)
kkxexe
kkotap (96 samples, 0.35%)
kkofhsmjk (126 samples, 0.45%)
kkepslCompCtl (1,403 samples, 5.05%)
kkepsl..
kkooqb (315 samples, 1.13%)
ssthrdmain (26,123 samples, 93.99%)
ssthrdmain
ttcpip (26,123 samples, 93.99%)
ttcpip
apaqbdDescendents (9,641 samples, 34.69%)
apaqbdDescendents
kkeidc (145 samples, 0.52%)
kkejeq (139 samples, 0.50%)
apaqbd (2,614 samples, 9.40%)
apaqbd
kkeIdxSelectivity (261 samples, 0.94%)
qcsprfro_tree (522 samples, 1.88%)
q..
kkojnp (1,049 samples, 3.77%)
kkojnp
qcpilcl0 (132 samples, 0.47%)
kkejnc (102 samples, 0.37%)
rpidrus (484 samples, 1.74%)
kketac (146 samples, 0.53%)
kkooqb (284 samples, 1.02%)
kkotap (1,257 samples, 4.52%)
kkotap
__exp1 (388 samples, 1.40%)
qcspqbDescendents (539 samples, 1.94%)
q..
kkoqbc (360 samples, 1.30%)
kkooqb (232 samples, 0.83%)
pfrrun_no_tool (26,122 samples, 93.98%)
pfrrun_no_tool
kkepsl (100 samples, 0.36%)
qksqbApplyToQbcLoc (12,795 samples, 46.04%)
qksqbApplyToQbcLoc
qcsprfro_tree (1,357 samples, 4.88%)
qcsprf..
opiosq (168 samples, 0.60%)
kkojnp (6,770 samples, 24.36%)
kkojnp
kkepsl (354 samples, 1.27%)
rpiswu2 (485 samples, 1.74%)
qcsprfro_tree (522 samples, 1.88%)
q..
kxsGetRuntimeLock (26,011 samples, 93.58%)
kxsGetRuntimeLock
kkqctCostTransfQB (3,213 samples, 11.56%)
kkqctCostTransfQB
qkspmPhysicalOptNextPred (199 samples, 0.72%)
kketac (132 samples, 0.47%)
kkepslCompCtl (225 samples, 0.81%)
kkepsl (653 samples, 2.35%)
k..
apadrv (174 samples, 0.63%)
kketac (907 samples, 3.26%)
kke..
kksLoadChild (141 samples, 0.51%)
kkonxc (664 samples, 2.39%)
k..
qksbgGetCursorVal (188 samples, 0.68%)
qcpibfa (132 samples, 0.47%)
kkotap (101 samples, 0.36%)
opiprs (127 samples, 0.46%)
kkoqbc (318 samples, 1.14%)
kkoiff (163 samples, 0.59%)
qksqbApplyToQbc (12,797 samples, 46.04%)
qksqbApplyToQbc
apaqbdDescendents (1,088 samples, 3.91%)
apaq..
kkejeq (1,145 samples, 4.12%)
kkejeq
kkoiqb (166 samples, 0.60%)
kkepslCompCtl (652 samples, 2.35%)
k..
qerhjComputeFanoutAndBPS (191 samples, 0.69%)
qksbgGetVal (121 samples, 0.44%)
rpiswu2 (26,051 samples, 93.73%)
rpiswu2
kkocnp (6,701 samples, 24.11%)
kkocnp
kkoqbc (473 samples, 1.70%)
kkonxc (680 samples, 2.45%)
kk..
kkessc (132 samples, 0.47%)
qcspqbDescendents (542 samples, 1.95%)
q..
apakkoqb (265 samples, 0.95%)
rpidrus (169 samples, 0.61%)
qcsprfro_tree (624 samples, 2.25%)
q..
opitca (425 samples, 1.53%)
kkoqbc (262 samples, 0.94%)
kkotap (131 samples, 0.47%)
kkmfcbloCbk (486 samples, 1.75%)
kkotap (95 samples, 0.34%)
pfrinstr_ICAL (26,118 samples, 93.97%)
pfrinstr_ICAL
apakkoqb (491 samples, 1.77%)
kkoiqb (115 samples, 0.41%)
kkepslCompCtl (351 samples, 1.26%)
kkoiqb (108 samples, 0.39%)
apaqbdDescendents (341 samples, 1.23%)
kkotap (147 samples, 0.53%)
opidrv (26,123 samples, 93.99%)
opidrv
qksbgGetVal (100 samples, 0.36%)
kkepslCompCtl (225 samples, 0.81%)
kkmfcbvw (1,341 samples, 4.82%)
kkmfcbvw
qkadrv (111 samples, 0.40%)
kkmevw (1,336 samples, 4.81%)
kkmevw
qcspqbDescendents (626 samples, 2.25%)
q..
qcsprfro (1,356 samples, 4.88%)
qcsprfro
kkofmx (131 samples, 0.47%)
kkoqbc (9,138 samples, 32.88%)
kkoqbc
kkessc (706 samples, 2.54%)
kk..
kkonxc (4,303 samples, 15.48%)
kkonxc
kkmevw (614 samples, 2.21%)
k..
__ieee754_pow (562 samples, 2.02%)
_..
kkqdrv (141 samples, 0.51%)
kkonxc (103 samples, 0.37%)
kkocnp (1,013 samples, 3.64%)
kkocnp
qksbgGetVal (157 samples, 0.56%)
kkoiqb (202 samples, 0.73%)
kkejcd (109 samples, 0.39%)
qksbgGetCursorVal (143 samples, 0.51%)
qknRwsAllocateTree (98 samples, 0.35%)
kkeEqJoinSel (187 samples, 0.67%)
kkofmx (495 samples, 1.78%)
kkeLogSel (108 samples, 0.39%)
kkepsl (138 samples, 0.50%)
kkeEqJoinSel (159 samples, 0.57%)
opikpr (26,037 samples, 93.68%)
opikpr
kkeidc (889 samples, 3.20%)
kke..
kkoPred (134 samples, 0.48%)
plsql_run (26,123 samples, 93.99%)
plsql_run
kprbprsu (26,052 samples, 93.73%)
kprbprsu
opimai_real (26,123 samples, 93.99%)
opimai_real
kkxs_parse_cbk (26,053 samples, 93.74%)
kkxs_parse_cbk
apakkoqb (674 samples, 2.42%)
ap..
kkocnp (1,063 samples, 3.82%)
kkocnp
qcsevw (626 samples, 2.25%)
q..
kkotap (740 samples, 2.66%)
kk..
apakkoqb (2,351 samples, 8.46%)
apakkoqb
kkeEqJoinSel (1,247 samples, 4.49%)
kkeEq..
kkejnc (433 samples, 1.56%)
kkooqb (398 samples, 1.43%)
kkooqb (264 samples, 0.95%)
kkosmsel (102 samples, 0.37%)
qknDoRwsAllocate (101 samples, 0.36%)
kkocnp (1,872 samples, 6.74%)
kkocnp
rpidrv (485 samples, 1.74%)
kkocnp (1,075 samples, 3.87%)
kkocnp
kkepslCompCtl (100 samples, 0.36%)
kkonxc (130 samples, 0.47%)
kkdlgvt (703 samples, 2.53%)
kk..
qksbgGetCursorVal (278 samples, 1.00%)
skgmstack (484 samples, 1.74%)
qcspafq (522 samples, 1.88%)
q..
kksfbc (468 samples, 1.68%)
kketac (110 samples, 0.40%)
apaqbdDescendents (9,633 samples, 34.66%)
apaqbdDescendents
kkotap (120 samples, 0.43%)
kprball (26,052 samples, 93.73%)
kprball
rpidrv (170 samples, 0.61%)
all (27,794 samples, 100%)
kkeEqJoinSel (121 samples, 0.44%)
kkepslCompCtl (99 samples, 0.36%)
kkejeq (1,163 samples, 4.18%)
kkejeq
kkonxc (609 samples, 2.19%)
k..
opiexe (26,123 samples, 93.99%)
opiexe
qkadrv (106 samples, 0.38%)
kkejcd (301 samples, 1.08%)
skgmstack (26,051 samples, 93.73%)
skgmstack
skgmstack (169 samples, 0.61%)
kkoiqb (149 samples, 0.54%)
kkocnp (120 samples, 0.43%)
kkojnp (205 samples, 0.74%)
kxsGetRuntimeLock (149 samples, 0.54%)
kkoPred (98 samples, 0.35%)
qksbgGetCursorVal (105 samples, 0.38%)
apaqbdDescendents (828 samples, 2.98%)
ap..
kkoiqb (103 samples, 0.37%)
kketac (3,539 samples, 12.73%)
kketac
kkmfcbloCbk (1,345 samples, 4.84%)
kkmfcb..
qkspmPhysicalOptNextPred (168 samples, 0.60%)
kkoitbp (139 samples, 0.50%)
kkepslCompCtl (643 samples, 2.31%)
k..
qcspqb (539 samples, 1.94%)
q..
qksbgGetVal (166 samples, 0.60%)
qcspqbDescendents (132 samples, 0.47%)
kkosmsel (110 samples, 0.40%)
kkooqb (103 samples, 0.37%)
qcpibfa (128 samples, 0.46%)
qksbgGetVal (356 samples, 1.28%)
kkeEqJoinSel (336 samples, 1.21%)
ktatminextsz (160 samples, 0.58%)
kketac (99 samples, 0.36%)
opiodr (169 samples, 0.61%)
kkestRCSBase (129 samples, 0.46%)
apakkoqb (8,287 samples, 29.82%)
apakkoqb
kkepsl (506 samples, 1.82%)
k..
apakkoqb (369 samples, 1.33%)
qksbgGetCursorVal (149 samples, 0.54%)
kksLoadChild (26,002 samples, 93.55%)
kksLoadChild
kkejeq (186 samples, 0.67%)
pfrrun (26,123 samples, 93.99%)
pfrrun
appget (323 samples, 1.16%)
kkotap (190 samples, 0.68%)
kkqctdrvST (9,476 samples, 34.09%)
kkqctdrvST
kkofhsmjk (137 samples, 0.49%)
apaqbdDescendents (158 samples, 0.57%)
kkercs (179 samples, 0.64%)
rpidrus (26,051 samples, 93.73%)
rpidrus
kkoiqb (227 samples, 0.82%)
qcspqbDescendents (190 samples, 0.68%)
kkessc (681 samples, 2.45%)
kk..
kkejeq (412 samples, 1.48%)
qksqbApplyToQbcLoc (9,481 samples, 34.11%)
qksqbApplyToQbcLoc
kkeidc (3,467 samples, 12.47%)
kkeidc
kkepslCompCtl (100 samples, 0.36%)
kkmfcbloCbk (618 samples, 2.22%)
k..
qknRwsAllocateTree (95 samples, 0.34%)
kkepslCompCtl (137 samples, 0.49%)
kkonxc (137 samples, 0.49%)
kkooqb (7,097 samples, 25.53%)
kkooqb
kkooqb (516 samples, 1.86%)
k..
kkmfcbvw (615 samples, 2.21%)
k..
qcpibex (127 samples, 0.46%)
kkeidc (539 samples, 1.94%)
k..
kkmevw (437 samples, 1.57%)
kkojnp (300 samples, 1.08%)
sou2o (26,123 samples, 93.99%)
sou2o
ktatminextsz (175 samples, 0.63%)
qcsprfro (624 samples, 2.25%)
q..
rpiswu2 (127 samples, 0.46%)
kketac (579 samples, 2.08%)
k..
kkotap (142 samples, 0.51%)
kkepsl (348 samples, 1.25%)
kkspsc0 (163 samples, 0.59%)
rpiswu2 (438 samples, 1.58%)
apaqbdDescendents (2,614 samples, 9.40%)
apaqbdDescend..
kkonxc (179 samples, 0.64%)
kkeEqJoinSel (284 samples, 1.02%)
qknRwsAllocateTree (101 samples, 0.36%)
qksbgGetCursorVal (631 samples, 2.27%)
q..
kkqctCostTransfQB (9,386 samples, 33.77%)
kkqctCostTransfQB
kksLoadChild (450 samples, 1.62%)
kkeIdxSelectivity (288 samples, 1.04%)
apakkoqb (9,138 samples, 32.88%)
apakkoqb
kkoitbp (132 samples, 0.47%)
kkojnp (117 samples, 0.42%)
kkoonlj (99 samples, 0.36%)
apaqbd (8,552 samples, 30.77%)
apaqbd
apaqbd (1,098 samples, 3.95%)
apaqbd
kkotap (4,785 samples, 17.22%)
kkotap
kkotap (4,865 samples, 17.50%)
kkotap
qksbgGetCursorVal (102 samples, 0.37%)
kkoqbc (658 samples, 2.37%)
k..
kksParseChildCursor (1,587 samples, 5.71%)
kksPars..
kkojnp (1,064 samples, 3.83%)
kkojnp
kkeidc (98 samples, 0.35%)
kkojnp (171 samples, 0.62%)
rpiexe (485 samples, 1.74%)
qksbgGetCursorVal (100 samples, 0.36%)
apaqbd (828 samples, 2.98%)
ap..
kkspsc0 (26,032 samples, 93.66%)
kkspsc0
kkessc (146 samples, 0.53%)
kksParseChildCursor (127 samples, 0.46%)
kkmpfcbk (1,345 samples, 4.84%)
kkmpfcbk
kkooqb (1,142 samples, 4.11%)
kkooqb
kkejeq (508 samples, 1.83%)
k..
opitsk (26,123 samples, 93.99%)
opitsk
kkepslLog (139 samples, 0.50%)
apakkoqb (157 samples, 0.56%)
kkepslCompCtl (375 samples, 1.35%)
kkocnp (205 samples, 0.74%)
appget (123 samples, 0.44%)
kkeEqJoinSel (194 samples, 0.70%)
apaqbdDescendents (1,084 samples, 3.90%)
apaq..
kkepslLog (114 samples, 0.41%)
kkxs_parse (26,054 samples, 93.74%)
kkxs_parse
apaqbdDescendents (263 samples, 0.95%)
opiprs (1,587 samples, 5.71%)
opiprs
kkepslCompCtl (206 samples, 0.74%)
prsvwq (154 samples, 0.55%)
kkooqb (168 samples, 0.60%)
kkejcd (157 samples, 0.56%)
kkoiqb (141 samples, 0.51%)
qksbgGetCursorVal (275 samples, 0.99%)
apadrv (23,900 samples, 85.99%)
apadrv
qcspafq (1,357 samples, 4.88%)
qcspafq
kkoqbc (152 samples, 0.55%)
qksbgGetCursorVal (638 samples, 2.30%)
q..
kkepslCompCtl (496 samples, 1.78%)
kksFullTypeCheck (429 samples, 1.54%)
kkoiqb (191 samples, 0.69%)
kkofmx (529 samples, 1.90%)
k..
kketac (3,522 samples, 12.67%)
kketac
kkepsl (109 samples, 0.39%)
kkepsl (657 samples, 2.36%)
k..
kkqdrv (13,086 samples, 47.08%)
kkqdrv
kkessc (200 samples, 0.72%)
apakkoqb (263 samples, 0.95%)
kkoiqb (112 samples, 0.40%)
kkotap (111 samples, 0.40%)
kkejcd (703 samples, 2.53%)
kk..
qcpibex (132 samples, 0.47%)
kkooqb (7,018 samples, 25.25%)
kkooqb
qcsprfro_tree (624 samples, 2.25%)
q..
kkofkrSetup (829 samples, 2.98%)
kk..
kkepsl (100 samples, 0.36%)
apaqbdDescendents (8,552 samples, 30.77%)
apaqbdDescendents
kkehrd (215 samples, 0.77%)
kkooqb (2,008 samples, 7.22%)
kkooqb
kkmdrv (1,380 samples, 4.97%)
kkmdrv
apaqbdDescendents (594 samples, 2.14%)
a..
kkqctdrvTD (12,876 samples, 46.33%)
kkqctdrvTD
kkonxc (1,109 samples, 3.99%)
kkonxc
qkaTraverseQkn (184 samples, 0.66%)
kkooqb (364 samples, 1.31%)
kkoqbc (489 samples, 1.76%)
qcpibex (128 samples, 0.46%)
opiexe (483 samples, 1.74%)
qkadrv2Post (266 samples, 0.96%)
kkmpfcbk (496 samples, 1.78%)
apaqbd (594 samples, 2.14%)
a..
apaqbdDescendents (265 samples, 0.95%)
appget (112 samples, 0.40%)
kkmfcbvw (453 samples, 1.63%)
opiodr (26,123 samples, 93.99%)
opiodr
kkoOrExpand (7,020 samples, 25.26%)
kkoOrExpand
kkepslCompCtl (1,370 samples, 4.93%)
kkepsl..
kkqstardrv (12,901 samples, 46.42%)
kkqstardrv
kkscsSearchChildList (466 samples, 1.68%)
kkejeq (176 samples, 0.63%)
kpoal8 (26,123 samples, 93.99%)
kpoal8
kkejcd (698 samples, 2.51%)
kk..
qcpivwq (154 samples, 0.55%)
qcspqbDescendents (1,369 samples, 4.93%)
qcspqb..
kkeEqJoinSel (447 samples, 1.61%)
kkxsprs (26,054 samples, 93.74%)
kkxsprs
qcsevw (191 samples, 0.69%)
__libc_start_main (26,123 samples, 93.99%)
__libc_start_main
kkeIdxSelectivity (456 samples, 1.64%)
opiodr (484 samples, 1.74%)
opiosq0 (26,035 samples, 93.67%)
opiosq0
kksParseCursor (26,033 samples, 93.66%)
kksParseCursor
kkoqbc (210 samples, 0.76%)
qcspqb (133 samples, 0.48%)
kkojnp (232 samples, 0.83%)
kkoOrExpand (7,103 samples, 25.56%)
kkoOrExpand
opiSem (1,547 samples, 5.57%)
opiSem
kkeEqJoinSel (286 samples, 1.03%)
qcspafq (624 samples, 2.25%)
q..
kkeIdxSelectivity (276 samples, 0.99%)
qcspqb (626 samples, 2.25%)
q..
kkojnp (6,635 samples, 23.87%)
kkojnp
kkoqbc (386 samples, 1.39%)
opiino (26,123 samples, 93.99%)
opiino
qcsprfro_tree (1,357 samples, 4.88%)
qcsprf..
kkqctdrvST (3,310 samples, 11.91%)
kkqctdrvST
kkqctdrvIT (13,140 samples, 47.28%)
kkqctdrvIT
apaqbdDescendents (408 samples, 1.47%)
kkmpfcbk (618 samples, 2.22%)
k..
kkeidc (570 samples, 2.05%)
k..
kkotap (139 samples, 0.50%)
kkocnp (101 samples, 0.36%)
kkeosl (107 samples, 0.38%)
kkejnc (390 samples, 1.40%)
kkoqbc (2,351 samples, 8.46%)
kkoqbc
apakkoqb (407 samples, 1.46%)
kkofkrSetup (1,099 samples, 3.95%)
kkof..
apaqbdDescendents (225 samples, 0.81%)
apakkoqb (225 samples, 0.81%)
opiSem (113 samples, 0.41%)
kkejeq (314 samples, 1.13%)
appget (121 samples, 0.44%)
kkofkrSetup (595 samples, 2.14%)
k..
appget (345 samples, 1.24%)
kksfbc (160 samples, 0.58%)
qcspqb (542 samples, 1.95%)
q..
kkejeq (421 samples, 1.51%)
kkehrd (236 samples, 0.85%)
kkepslCompCtl (181 samples, 0.65%)
kksParseCursor (163 samples, 0.59%)
qknRwsAllocateTree (98 samples, 0.35%)
kkoiqb (165 samples, 0.59%)
qksbgGetCursorVal (210 samples, 0.76%)
kkotap (738 samples, 2.66%)
kk..
kksSetBindType (456 samples, 1.64%)
main (26,123 samples, 93.99%)
main
kkejeq (535 samples, 1.92%)
k..
kkercs (157 samples, 0.56%)
kkeEqJoinSel (197 samples, 0.71%)
qksqbApplyToQbcLoc (12,793 samples, 46.03%)
qksqbApplyToQbcLoc
kkepsl (489 samples, 1.76%)
kkonxc (132 samples, 0.47%)
opiall0 (26,036 samples, 93.67%)
opiall0
kkeEqJoinSel (1,247 samples, 4.49%)
kkeEq..
kkocnp (6,842 samples, 24.62%)
kkocnp
rpiswu2 (170 samples, 0.61%)
kkooqb (1,164 samples, 4.19%)
kkooqb
apaqbdDescendents (9,631 samples, 34.65%)
apaqbdDescendents
qksbgGetVal (363 samples, 1.31%)
qksbgGetCursorVal (218 samples, 0.78%)
qcpiqbk (152 samples, 0.55%)
kkooqb (218 samples, 0.78%)
opiodr (26,051 samples, 93.73%)
opiodr
qknRwsAllocateTree (97 samples, 0.35%)
kkocnp (131 samples, 0.47%)
kkestRCSBase (127 samples, 0.46%)
rpisplu_internal (170 samples, 0.61%)
kkepslCompCtl (134 samples, 0.48%)
rpiswu2 (1,587 samples, 5.71%)
rpiswu2
qcspqb (191 samples, 0.69%)
kkeEqJoinSel (575 samples, 2.07%)
k..
qcpibfa (126 samples, 0.45%)
kketac (549 samples, 1.98%)
k..
kkoOrExpand (1,142 samples, 4.11%)
kkoO..
kkojnp (1,853 samples, 6.67%)
kkojnp
kkoqbc (8,285 samples, 29.81%)
kkoqbc
kkepslCompCtl (485 samples, 1.74%)
qcsprfro (522 samples, 1.88%)
q..
opiodr (26,123 samples, 93.99%)
opiodr
kkeidc (489 samples, 1.76%)
kkepsl (99 samples, 0.36%)
qkadrv2 (113 samples, 0.41%)
kkojnp (1,004 samples, 3.61%)
kkojnp
kkojnp (100 samples, 0.36%)
qkadrv (123 samples, 0.44%)
qcpilcl (132 samples, 0.47%)
kkeIdxSelectivity (1,878 samples, 6.76%)
kkeIdxSel..