Database Administration (MOSC)

MOSC Banner

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')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center