We have 4-5 people as DBAs. we login with a default id of sysdba. I want to know the individual name , terminal details etc from where one is logging using the common id sysdba.
Is there a dbc table/query to find that
dbc.LogonOffV holds the history of logons/logoffs and there's a column named LogonSource, which includes the network username.
The same column is in dbc.QryLogV, but it's also split into AppId, ClientId and ClientAddr.