Skip to content

Instantly share code, notes, and snippets.

@xtender
Created February 14, 2023 17:17
Show Gist options
  • Save xtender/2518cfde24f580970898682306579621 to your computer and use it in GitHub Desktop.
Save xtender/2518cfde24f580970898682306579621 to your computer and use it in GitHub Desktop.
trace 'alter table' by callstack
SQL> alter session set events 'sql_trace {callstack: fprefix atb} errorstack(1)';
Session altered.
SQL> begin execute immediate 'alter table dd add b int';end;
2 /
PL/SQL procedure successfully completed.
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0)
----- Error Stack Dump -----
<error barrier> at 0x7ffe52ad1db0 placed dbkda.c@296
----- Current SQL Statement for this session (sql_id=ggx91ms9duqbz) -----
alter table dd add b int
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x7977d758 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment