Unanswered: Retreiving data from v$session and V$sql
I am writing a program that stores sqls that executed by users every X seconds.
I encounterted a situation that every once in a while I get that a user SYS performed an sql statement that I know for a fact that he did not do,
It seems that some sessions start as user SYS and replaced the username at some point, but the the sql_address field is filled before the username is updated so at a certain moment is seems as if user SYS executed the sql. have you encounterd such problem and I can I prevert it?