Hi everyone,
I'm hoping someone can help me look in the right table.
I'm trying to find out what computers were used when anyone connected to the database in the last 6 months.
I've found v$session can show me who's currently connected but I'm looking for historical information.
SELECT username, machine, program
FROM v$session
WHERE type = 'USER';
Thank for any help or discussion information.
Mike