[oaktable] Re: function names for row source operators

  • From: Randolf Eberle-Geist <randolf.geist@xxxxxxxxxxxxxxxxxxxxx>
  • To: oaktable@xxxxxxxxxxxxx, Cary Millsap <cary.millsap@xxxxxxxxxxxx>
  • Date: Thu, 10 Dec 2020 08:57:40 +0100

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 Expert
http://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>/

Other related posts: