enable sql_trace=true in init.ora
OR match OS pid of long running connection with Oracle sid and username and find the sql.
thanks
GP