Hi Frits.
I couldn't find these:
qbctjp - Query Block ? Transitive Join Predicate
kdiprsp1 - ?
kkobsn - Sorting bitmap access according to cost
kkosjt - Kernel Compile Optimizer ???
sorget - Sort Support Routines. Sort Get. Advance to next record.
kkoarl - Kernel Compile Optimizer Calculate/Compute average row length
frofkks / frofkke - Index start/stop key (not sure if they are real
functions)
kdxdtr - Event to dump index tree?
ksdfal - trace_buffer_on ?
ksdffh - trace_buffer_off ?
ksdcca - Context Area
kqldmp - Library cache dump ?
Take care /Jocke
2020-12-10 16:33 skrev Frits Hoogland:
The annotation of the functions that hint at a rowsource are off course all
in http://orafun.info [4]. ;
If anyone knows a function or functions that are not in orafun.info [4] yet,
I am happy to include them.
If anyone finds an error, I am happy to correct it too.
Frits
On 10 Dec 2020, at 15:53, Cary Millsap <cary.millsap@xxxxxxxxxxxx> wrote:
Niall, Randolf, and Lothar: That's perfect; thank you very much!
Cary Millsap
Method R Corporation
Author of _Optimizing Oracle Performance [5]_
and _The Method R Guide to Mastering Oracle Trace Data, 3rd edition [6]_
On Thu, Dec 10, 2020 at 2:09 AM Lothar Flatz <l.flatz@xxxxxxxxxx> wrote:
Hi,
there is also this article:
https://tanelpoder.com/2013/02/14/troubleshooting-high-cpu-usage-with-poor-mans-stack-profiler-in-a-one-liner/
[7]
However I suppose runtime stats is easier, unless you have an os issue....
Regards
Lothar
Am 10.12.2020 um 08:57 schrieb Randolf Eberle-Geist:
You might be remembering Tanel's work from long time ago:
https://tanelpoder.com/2008/06/15/advanced-oracle-troubleshooting-guide-part-6-understanding-oracle-execution-plans-with-os_explain/
[8]
https://github.com/tanelpoder/tpt-oracle/blob/master/tools/unix/os_explain ;
[9]
Cheers,
Randolf
--
oracle-performance.de [1]
Oracle Database Performance Troubleshooting Expert
http://www.oracle-performance.de [2]
Phone: +49 170 758 1171
Datenschutzerklärung: http://www.oracle-performance.de/datenschutzerklaerung ;
[3]
Umsatzsteuer / VAT ID: DE213366879
Am 09.12.2020 um 22:37 schrieb Cary Millsap:
My Google Fu is not serving me well today...
I thought I had remembered seeing a catalog of Oracle internal function names
(the ones you'd see in _pstack_ output) and their mappings to Oracle's row
source operator names (like "INDEX RANGE SCAN...").
Did I just dream that? Or is it there and I'm just not finding it?
TIA!
Cary Millsap
Method R Corporation
Author of _Optimizing Oracle Performance [5]_
and _The Method R Guide to Mastering Oracle Trace Data, 3rd edition [6]_