select ksppinm "Parameter Name", ksppstvl "Value",ksppstdf "Default"
from x$ksppi x, x$ksppcv y
where x.indx = y.indx
and ksppinm like '/_%trace%' escape '/';

Tracing by Enabling Events
Alter session set events '10046 trace name context forever, level 1';
Alter session set events '10046 trace name context off';

level 1= sql_trace=true
level 4=level 1+bind variable
level 8=level 1+wait event
level 12=level1+bind variable+wait event

ITPub博客

隐藏的trace参数,trace event

最新文章