Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)

MOSC Banner

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

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