New feature: application tracing •Set options in another session •Display executing SQL in another session •Capture output from that other session into a file set tracefile ‘/tmp/spid36.out’ for 36 go — ’set’ commands apply to session 36 from now on set showplan on set show_sqltext on go — disable tracing again set tracefile off set tracefile off for 36