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> 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/
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://github.com/tanelpoder/tpt-oracle/blob/master/tools/unix/os_explain
Cheers,
Randolf
--oracle-performance.de
Oracle Database Performance Troubleshooting
Experthttp://www.oracle-performance.de
Phone: +49 170 758 1171
Datenschutzerklärung: 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>*