"set timing on" will work only in sqlplus.

you can look in v$session_longops view.