Search notes:

oradebug action: shortstack

SQL> oradebug doc event action shortstack
shortstack
        - get short stack (up to 256 characters)
showoffsets controls display of code offsets
skipframes can be used to overcome 256 char limit
Usage
-------
shortstack( skipframes      <ub8> default '0',
            showoffsets     < false | true > default 'false',
            Action returns: <string>[256])

Test

In «oradebug» session:
SQL> oradebug setospid 13240
SQL> oradebug event trace[RDBMS.SQL_Compiler] trace("shortstack: %\n", shortstack())
SQL> oradebug tracefile_name
In «debugged» session
select
  …

See also

The action callstack
oradebug short_stack

Index