search

tanelpoder / tpt-oracle

Tanel Poder's Performance & Troubleshooting Tools for Oracle Databases
https://tanelpoder.com
Other
648 stars 307 forks source link

add a script to generate an optimizer trace from the cursor cache #35

Closed martincarstenbach closed 2 years ago

martincarstenbach commented 2 years ago

Why this change

There is currently no script in the tpt suite allowing the creation of an optimizer trace from the cursor cache. As explained in this blog post by Maria Colgan it is possible to generate a 10053 trace without the need of a new hard parse. This might be useful in some situations where a hard parse can lead to bad performance.

What is changing

A new script, 53trace.sql has been added.

tanelpoder commented 2 years ago

Great, I have been thinking of doing this for years, now we have it, thanks :-)