ASH report for Oracle database 19.3

Hi all,

We recently had to do some audit work on one of Our Oracle databases and I decided to have a look at some of the historic connections using DBA_HIST_ACTIVE_SESS_HISTORY

The query is used was as follows:-

select c.username,a.SAMPLE_TIME, a.SQL_OPNAME, a.SQL_EXEC_START, a.program, a.module, a.machine,

b.SQL_TEXT

from DBA_HIST_ACTIVE_SESS_HISTORY a, dba_hist_sqltext b, dba_users c

where a.SQL_ID = b.SQL_ID(+)

and a.user_id=c.user_id

order by a.SQL_EXEC_START asc

When I looked at the data returned I could see a number of connections from different hosts as "SYS" which really concerned me ! A sample of the report is attached in the spreadsheet. As you can see there are different hosts appearing (I've changed the server names for security purposes). I flagged this up with the owners of these hosts and after investigation from there side they informed me that not one there connection strings were using SYS ! I'm a little confused now at the validity of the SQL I used to run