How can I view all SQL statements run from a apex session.
577917Jan 3 2011 — edited Jan 4 2011Hello, I hope to get some expert help on this one.
By quering apex_workspace_activity_log I can get the apex_session_id for some slow running pages (slow only for some users).
My question is is there a way to view a log of all sql statements run by a particular apex session. For example quering the v$sql . I can't find a full description of all fields in v$sql and I don't know how to link a sql to the user experiencing the slowness.