session_user from sys_context
Hello,
I created an on logon trigger.
In the trigger, I am capturing the session user and inserting the information in a table.
It appears the table somehow contains information of users that logged in a few days ago. I truncated the table and I restarted the instance and logged into the database and the information is still in the table coming from the sys_context function of old connections..
My question is why the information in the table still show old information from old sys_context ?
Below is a partial example of how I use the function.
sys_context('USERENV','SESSION_USER')