You guys are not answering OP's question.
Providing you know the username of the user you want to track you might want to try:
Code:select a.username, b.last_load_time, b.sql_text from v$session a, v$sql b where a.username = 'USERNAME_YOU_WANT_TO_TRACK' and a.sql_address = address order by b.last_load_time desc ;




Reply With Quote