Flame Graph: parsing of select count(*) from dba_source, CBO 12.1.0.1 with adaptive optimzations
kkofkrSetup (900 samples, 1.57%)
kkoqbc (248 samples, 0.43%)
kdiss_mf_sc (5,597 samples, 9.76%)
kdiss_mf_sc
kafger_srp (522 samples, 0.91%)
appget (358 samples, 0.62%)
evareo (220 samples, 0.38%)
ktrget2 (483 samples, 0.84%)
qkspmPhysicalOptNextPred (239 samples, 0.42%)
opiodr (54,528 samples, 95.12%)
opiodr
kkeIdxSelectivity (1,303 samples, 2.27%)
k..
kkeAdjIndexSel (27,973 samples, 48.80%)
kkeAdjIndexSel
kkmfcbvw (577 samples, 1.01%)
apaqbdDescendents (249 samples, 0.43%)
qosdInitDirCtx (464 samples, 0.81%)
kkoiqb (9,621 samples, 16.78%)
kkoiqb
kkonxc (9,464 samples, 16.51%)
kkonxc
hrtimer_interrupt (272 samples, 0.47%)
__poll (367 samples, 0.64%)
SELECT FETCH: (27,630 samples, 48.20%)
SELECT FETCH:
SELECT FETCH: (9,188 samples, 16.03%)
SELECT FETCH:
qcspqbDescendents (712 samples, 1.24%)
apaqbdDescendents (620 samples, 1.08%)
kglsscn (447 samples, 0.78%)
qksqbApplyToQbc (52,052 samples, 90.80%)
qksqbApplyToQbc
opiall0 (27,821 samples, 48.53%)
opiall0
pfrinstr_ICAL (54,526 samples, 95.12%)
pfrinstr_ICAL
_intel_fast_memcmp (390 samples, 0.68%)
qcsprfro_tree (816 samples, 1.42%)
qosdGetExistingKglObj (316 samples, 0.55%)
kketac (340 samples, 0.59%)
evaiand (314 samples, 0.55%)
VIEW: Fetch (9,169 samples, 15.99%)
VIEW: Fetch
all (57,325 samples, 100%)
kkeidc (9,440 samples, 16.47%)
kkeidc
apaqbdDescendents (458 samples, 0.80%)
qksqbApplyToQbcLoc (51,044 samples, 89.04%)
qksqbApplyToQbcLoc
qksdsExecute (27,926 samples, 48.72%)
qksdsExecute
qerscFetch (351 samples, 0.61%)
ssthrdmain (54,528 samples, 95.12%)
ssthrdmain
rpiswu2 (9,317 samples, 16.25%)
rpiswu2
rpidrus (9,316 samples, 16.25%)
rpidrus
kkojnp (829 samples, 1.45%)
kkqctdrvST (1,001 samples, 1.75%)
evaior (2,023 samples, 3.53%)
eva..
upirtrc (381 samples, 0.66%)
kdiss_mf_ge (1,678 samples, 2.93%)
kd..
qosdGetKglObj (313 samples, 0.55%)
kdiss_mf_rcmkcp (505 samples, 0.88%)
kcbgtcr (415 samples, 0.72%)
kkoiqb (5,397 samples, 9.41%)
kkoiqb
kkocnp (5,395 samples, 9.41%)
kkocnp
TABLE ACCESS: Fetch (5,151 samples, 8.99%)
TABLE ACCESS..
qcspqbDescendents (707 samples, 1.23%)
kkepslCompCtl (448 samples, 0.78%)
kkooqb (253 samples, 0.44%)
local_apic_timer_interrupt (273 samples, 0.48%)
opikpr (27,839 samples, 48.56%)
opikpr
GROUP BY SORT: Fetch (9,168 samples, 15.99%)
GROUP BY SORT: Fetch
pevm_icd_call_common (54,526 samples, 95.12%)
pevm_icd_call_common
qcspafq (816 samples, 1.42%)
kkmfcbloCbk (646 samples, 1.13%)
kkqctdrvST (51,037 samples, 89.03%)
kkqctdrvST
expepr (1,889 samples, 3.30%)
exp..
kkmevw (559 samples, 0.98%)
kkoqbc (433 samples, 0.76%)
kkqctCostTransfQB (50,938 samples, 88.86%)
kkqctCostTransfQB
skgmstack (54,463 samples, 95.01%)
skgmstack
kkooqb (211 samples, 0.37%)
kkoatVerifyIdxAcc (9,379 samples, 16.36%)
kkoatVerifyIdxAcc
kkmevw (805 samples, 1.40%)
kdiss_mf_le (1,411 samples, 2.46%)
kd..
opiSem (1,168 samples, 2.04%)
o..
qcsevw (819 samples, 1.43%)
ktrget2 (1,506 samples, 2.63%)
kt..
apakkoqb (28,532 samples, 49.77%)
apakkoqb
HASH JOIN: ComputeFanoutAndBPS (205 samples, 0.36%)
apakkoqb (248 samples, 0.43%)
expepr (828 samples, 1.44%)
qcsprfro (684 samples, 1.19%)
GROUP BY SORT: Fetch (27,581 samples, 48.11%)
GROUP BY SORT: Fetch
kkotap (3,829 samples, 6.68%)
kkotap
kkotap (28,233 samples, 49.25%)
kkotap
kkooqb (213 samples, 0.37%)
NESTED LOOP JOIN: Fetch (352 samples, 0.61%)
qcspqb (263 samples, 0.46%)
kketac (2,476 samples, 4.32%)
kketac
GROUP BY SORT: Fetch (371 samples, 0.65%)
NESTED LOOP JOIN: Fetch (301 samples, 0.53%)
kkessc (518 samples, 0.90%)
opiall0 (9,300 samples, 16.22%)
opiall0
expeal (1,086 samples, 1.89%)
e..
opikpr (5,244 samples, 9.15%)
opikpr
kkxs_parse_cbk (54,464 samples, 95.01%)
kkxs_parse_cbk
prsvwq (221 samples, 0.39%)
kkmdrv (952 samples, 1.66%)
qcsprfro (816 samples, 1.42%)
qcsprfro_tree (913 samples, 1.59%)
__run_hrtimer (262 samples, 0.46%)
INDEX: FetchSkipScan (17,178 samples, 29.97%)
INDEX: FetchSkipScan
kkoOrExpand (15,127 samples, 26.39%)
kkoOrExpand
kxsGetRuntimeLock (54,441 samples, 94.97%)
kxsGetRuntimeLock
rpidrus (5,248 samples, 9.15%)
rpidrus
plsql_run (54,528 samples, 95.12%)
plsql_run
kdiss_fetch (17,037 samples, 29.72%)
kdiss_fetch
apakkoqb (456 samples, 0.80%)
kksLoadChild (54,434 samples, 94.96%)
kksLoadChild
kkspsc0 (54,463 samples, 95.01%)
kkspsc0
rwsfcd (303 samples, 0.53%)
kkmfcbloCbk (898 samples, 1.57%)
kkofmx (534 samples, 0.93%)
kkeAdjIndexSel (9,381 samples, 16.36%)
kkeAdjIndexSel
ktrget2 (726 samples, 1.27%)
opikpr (54,463 samples, 95.01%)
opikpr
kcbrls (212 samples, 0.37%)
kkejnc (420 samples, 0.73%)
kkxexe (54,528 samples, 95.12%)
kkxexe
qcspafq (685 samples, 1.19%)
apaqbd (620 samples, 1.08%)
kdstgr (328 samples, 0.57%)
kpufch (385 samples, 0.67%)
opiosq0 (54,463 samples, 95.01%)
opiosq0
kkotap (604 samples, 1.05%)
kkxsprs (54,466 samples, 95.01%)
kkxsprs
kkejcd (316 samples, 0.55%)
kkeidc (2,396 samples, 4.18%)
kkeidc
SELECT FETCH: (5,215 samples, 9.10%)
SELECT FETCH:
NESTED LOOP JOIN: Fetch (256 samples, 0.45%)
kprbprsu (54,464 samples, 95.01%)
kprbprsu
kkoqbc (28,529 samples, 49.77%)
kkoqbc
opiexe (54,528 samples, 95.12%)
opiexe
kkoadsTimeLimitFromSrc (463 samples, 0.81%)
qcspqb (935 samples, 1.63%)
kdiss_mf_insf (477 samples, 0.83%)
skgmstack (5,248 samples, 9.15%)
skgmstack
VIEW: Fetch (372 samples, 0.65%)
kafger_srp (1,742 samples, 3.04%)
kaf..
kkmpfcbk (898 samples, 1.57%)
kkotap (5,335 samples, 9.31%)
kkotap
kkocnp (840 samples, 1.47%)
kkeidc (28,133 samples, 49.08%)
kkeidc
kkmfcbvw (809 samples, 1.41%)
qcsprfro_tree (684 samples, 1.19%)
kkojnp (5,315 samples, 9.27%)
kkojnp
kkonxc (446 samples, 0.78%)
sou2o (54,528 samples, 95.12%)
sou2o
kqlsscn (447 samples, 0.78%)
kkooqb (6,261 samples, 10.92%)
kkooqb
qcsprfro_tree (684 samples, 1.19%)
kkoqbc (21,493 samples, 37.49%)
kkoqbc
kkecdn (5,296 samples, 9.24%)
kkecdn
kkmevw (888 samples, 1.55%)
opimai_real (54,528 samples, 95.12%)
opimai_real
qksqbApplyToQbcLoc (52,049 samples, 90.80%)
qksqbApplyToQbcLoc
kkeEqJoinSel (269 samples, 0.47%)
IN-LIST: InitializeInList (414 samples, 0.72%)
qcsevw (712 samples, 1.24%)
kprball (27,875 samples, 48.63%)
kprball
evareo (639 samples, 1.11%)
opiodr (379 samples, 0.66%)
kksParseCursor (54,463 samples, 95.01%)
kksParseCursor
kpoodr (381 samples, 0.66%)
smp_apic_timer_interrupt (307 samples, 0.54%)
apakkoqb (277 samples, 0.48%)
kketac (9,443 samples, 16.47%)
kketac
ktrget2 (760 samples, 1.33%)
kkoiqb (245 samples, 0.43%)
opifch (379 samples, 0.66%)
qerscFetchBuffer (351 samples, 0.61%)
qcspqb (707 samples, 1.23%)
kdstgr (7,073 samples, 12.34%)
kdstgr
kkmpfcbk (811 samples, 1.41%)
apaqbd (899 samples, 1.57%)
kdiss_pin_hdr (753 samples, 1.31%)
__ieee754_pow (273 samples, 0.48%)
qosdPopulateOptDir (437 samples, 0.76%)
NESTED LOOP JOIN: Fetch (351 samples, 0.61%)
TABLE ACCESS: Fetch (8,922 samples, 15.56%)
TABLE ACCESS: Fetch
qcspafq (913 samples, 1.59%)
qosdGetOptDir (459 samples, 0.80%)
TABLE ACCESS: Fetch (10,278 samples, 17.93%)
TABLE ACCESS: Fetch
opitsk (54,528 samples, 95.12%)
opitsk
expeal (1,936 samples, 3.38%)
exp..
kkooqb (328 samples, 0.57%)
kpufch0 (383 samples, 0.67%)
HASH JOIN: Fetch (351 samples, 0.61%)
tick_sched_timer (256 samples, 0.45%)
main (54,528 samples, 95.12%)
main
VIEW: Fetch (27,584 samples, 48.12%)
VIEW: Fetch
opiino (54,528 samples, 95.12%)
opiino
evareo (825 samples, 1.44%)
kkoqbc (256 samples, 0.45%)
qcsevw (263 samples, 0.46%)
kdstgr (3,343 samples, 5.83%)
kdstgr
skgmstack (27,863 samples, 48.61%)
skgmstack
rpidrus (54,463 samples, 95.01%)
rpidrus
apaqbdDescendents (28,533 samples, 49.77%)
apaqbdDescendents
evaiand (973 samples, 1.70%)
qcspqbDescendents (818 samples, 1.43%)
kkeAdjSingTabCard (5,280 samples, 9.21%)
kkeAdjSingTab..
kprball (54,463 samples, 95.01%)
kprball
qksdsExeStmt (27,921 samples, 48.71%)
qksdsExeStmt
rpiswu2 (1,194 samples, 2.08%)
r..
kpurcsc (381 samples, 0.66%)
qksdsExeStmt (9,338 samples, 16.29%)
qksdsExeStmt
apaqbdDescendents (248 samples, 0.43%)
qcsprfro_tree (816 samples, 1.42%)
kpoodrc (379 samples, 0.66%)
kdstgr (2,158 samples, 3.76%)
kdstgr
kkqctdrvIT (52,286 samples, 91.21%)
kkqctdrvIT
opiodr (5,248 samples, 9.15%)
opiodr
kkoiqb (203 samples, 0.35%)
kkqctCostTransfQB (876 samples, 1.53%)
kkoatVerifyIdxAcc (27,970 samples, 48.79%)
kkoatVerifyIdxAcc
kcbgtcr (629 samples, 1.10%)
qcspqb (818 samples, 1.43%)
qcspqbDescendents (259 samples, 0.45%)
opiodr (54,463 samples, 95.01%)
opiodr
kcbgtcr (1,320 samples, 2.30%)
k..
opiall0 (5,241 samples, 9.14%)
opiall0
__libc_start_main (54,528 samples, 95.12%)
__libc_start_main
SELECT FETCH: (378 samples, 0.66%)
kdiss_mf_rcmkcp (345 samples, 0.60%)
kkooqb (15,125 samples, 26.38%)
kkooqb
kafger_srp (1,351 samples, 2.36%)
k..
kkeidc (335 samples, 0.58%)
apaqbd (50,033 samples, 87.28%)
apaqbd
kksfbc (54,449 samples, 94.98%)
kksfbc
qcpiqex (219 samples, 0.38%)
kkoqbc (428 samples, 0.75%)
kkmfcbloCbk (810 samples, 1.41%)
apaqbd (249 samples, 0.43%)
NESTED LOOP JOIN: Fetch (303 samples, 0.53%)
qcsprfro (912 samples, 1.59%)
kprball (9,317 samples, 16.25%)
kprball
opiodr (54,528 samples, 95.12%)
opiodr
expeal (2,133 samples, 3.72%)
expeal
kpoal8 (54,528 samples, 95.12%)
kpoal8
apakkoqb (440 samples, 0.77%)
rpiswu2 (379 samples, 0.66%)
opiodr (9,316 samples, 16.25%)
opiodr
rpiswu2 (5,249 samples, 9.16%)
rpiswu2
opitca (53,236 samples, 92.87%)
opitca
kkqctdrvTD (52,126 samples, 90.93%)
kkqctdrvTD
apakkoqb (339 samples, 0.59%)
kkoqbc (330 samples, 0.58%)
opiprs (1,194 samples, 2.08%)
o..
HASH JOIN: Fetch (352 samples, 0.61%)
kkqdrv (52,272 samples, 91.19%)
kkqdrv
apadrv (53,234 samples, 92.86%)
apadrv
qcspqbDescendents (935 samples, 1.63%)
evainlo (1,138 samples, 1.99%)
e..
kkmpfcbk (654 samples, 1.14%)
qksdsExeStmt (5,254 samples, 9.17%)
qksdsExeStmt
qksdsExecute (9,340 samples, 16.29%)
qksdsExecute
kkmfcbvw (892 samples, 1.56%)
kkotap (9,541 samples, 16.64%)
kkotap
qksqbApplyToQbcLoc (52,047 samples, 90.79%)
qksqbApplyToQbcLoc
kkessc (28,044 samples, 48.92%)
kkessc
apaqbdDescendents (50,032 samples, 87.28%)
apaqbdDescendents
lmebco (230 samples, 0.40%)
IN-LIST: evao (1,086 samples, 1.89%)
I..
kkessc (9,407 samples, 16.41%)
kkessc
apaqbdDescendents (899 samples, 1.57%)
peicnt (54,528 samples, 95.12%)
peicnt
kkoadsInitCtx (482 samples, 0.84%)
opidrv (54,528 samples, 95.12%)
opidrv
expepr (266 samples, 0.46%)
apaqbdDescendents (279 samples, 0.49%)
kdiss_mf_rcmkcp (471 samples, 0.82%)
opiall0 (54,463 samples, 95.01%)
opiall0
kkooqb (354 samples, 0.62%)
qksdsExecute (5,256 samples, 9.17%)
qksdsExecute
OCIStmtFetch (385 samples, 0.67%)
kksParseChildCursor (1,194 samples, 2.08%)
k..
apic_timer_interrupt (309 samples, 0.54%)
rpiswu2 (27,866 samples, 48.61%)
rpiswu2
kprball (5,249 samples, 9.16%)
kprball
kkonxc (28,153 samples, 49.11%)
kkonxc
lmebco (209 samples, 0.36%)
kkoiqb (28,273 samples, 49.32%)
kkoiqb
kkonxc (3,240 samples, 5.65%)
kkonxc
rpidrus (27,862 samples, 48.60%)
rpidrus
kkxs_parse (54,466 samples, 95.01%)
kkxs_parse
apakkoqb (21,497 samples, 37.50%)
apakkoqb
ttcpip (54,528 samples, 95.12%)
ttcpip
kkoatVerifyEst (5,276 samples, 9.20%)
kkoatVerifyEst
qcpivwq (221 samples, 0.39%)
qcsprfro_tree (913 samples, 1.59%)
kkofkrSetup (622 samples, 1.09%)
qcspqb (712 samples, 1.24%)
kdiss_mf_backf (1,528 samples, 2.67%)
kd..
rwsfcd (352 samples, 0.61%)
kkooqb (28,482 samples, 49.69%)
kkooqb
kcbgtcr (587 samples, 1.02%)
skgmstack (9,316 samples, 16.25%)
skgmstack
evareo (668 samples, 1.17%)
opiodr (27,861 samples, 48.60%)
opiodr
kkoadsTimeLimit (463 samples, 0.81%)
opikpr (9,309 samples, 16.24%)
opikpr
qcpiqbk (219 samples, 0.38%)
GROUP BY SORT: Fetch (5,210 samples, 9.09%)
GROUP BY SORT..
kkejeq (214 samples, 0.37%)
pfrrun (54,528 samples, 95.12%)
pfrrun
kketac (28,136 samples, 49.08%)
kketac
pfrrun_no_tool (54,528 samples, 95.12%)
pfrrun_no_tool
kkqstardrv (52,160 samples, 90.99%)
kkqstardrv
rpiswu2 (54,463 samples, 95.01%)
rpiswu2