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])
SQL> oradebug setospid 13240 SQL> oradebug event trace[RDBMS.SQL_Compiler] trace("shortstack: %\n", shortstack()) SQL> oradebug tracefile_name
select …