The annotation of the functions that hint at a rowsource are off course all in
http://orafun.info ;<http://orafun.info/>.
If anyone knows a function or functions that are not in orafun.info
<http://orafun.info/> 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 <http://amzn.to/OM0q75>
and The Method R Guide to Mastering Oracle Trace Data, 3rd edition
<https://amzn.to/2IhhCG6+-+Millsap+2019.+Mastering+Oracle+Trace+Data+3ed>
On Thu, Dec 10, 2020 at 2:09 AM Lothar Flatz <l.flatz@xxxxxxxxxx
<mailto: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/
<https://tanelpoder.com/2013/02/14/troubleshooting-high-cpu-usage-with-poor-mans-stack-profiler-in-a-one-liner/>
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/
<https://tanelpoder.com/2008/06/15/advanced-oracle-troubleshooting-guide-part-6-understanding-oracle-execution-plans-with-os_explain/>
https://github.com/tanelpoder/tpt-oracle/blob/master/tools/unix/os_explain ;
<https://github.com/tanelpoder/tpt-oracle/blob/master/tools/unix/os_explain>
Cheers,
Randolf
--
oracle-performance.de <http://oracle-performance.de/>
Oracle Database Performance Troubleshooting Expert
http://www.oracle-performance.de ;<http://www.oracle-performance.de/>
Phone: +49 170 758 1171
Datenschutzerklärung: http://www.oracle-performance.de/datenschutzerklaerung ;
<http://www.oracle-performance.de/datenschutzerklaerung>
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 <http://amzn.to/OM0q75>
and The Method R Guide to Mastering Oracle Trace Data, 3rd edition
<https://amzn.to/2IhhCG6+-+Millsap+2019.+Mastering+Oracle+Trace+Data+3ed>
