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