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