Re: Query ASH for Undo Blocks

Hello Jonathan,
this might be a little bit tricky without evaluating the function arguments - AFAIK you can only specify if a specific function is on the stack but not evaluate its parameters inside the event.

Just did a quick PinTools on "select 1 from dual". For example: -> ksulbem(0x1, 0x57b, ...) = At the end when an ORA-1403 is send to client (0x57b)

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Jonathan Lewis <jlewisoracle_at_gmail.com> hat am 15.06.2022 09:32 CEST geschrieben:
>
>
>
> Stefan,
>
> Following some of the examples of the newer trace mechanism that you and Tanel have published - can you think up a specification for tracing that would allow the process stats to be dumped to trace for a given SQL_ID at the start of call and end of fetch? I think there's a PROCSTAT call from oradebug, but would have to do some research to see if I could get the effect from "set events".
>
> Regards
> Jonathan Lewis

--
http://www.freelists.org/webpage/oracle-l