No question at this time
DBA Top 10
1 M. Cadot 13000
2 B. Vroman 7000
3 A. Kavsek 5900
4 J. Schnackenberg 3200
5 P. Wisse 2600
6 J. PĂ©ran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48600
Total active users1396
Act. users last 24h1
Act. users last hour1
Registered user hits last week51
Registered user hits last month385
Go up

How to monitor and report SYS actions
Next thread: How much number of records we should keep in the oracle table
Prev thread: OEM Cloud Control alternative

Message Score Author Date
Hi Team, Is there a way to monitor all the acti...... S SPB Mar 24, 2021, 08:17
Same answer than in your previous thread about t...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Mar 24, 2021, 08:28

Follow up by mail Click here


Subject: How to monitor and report SYS actions
Author: S SPB, India
Date: Mar 24, 2021, 08:17, 29 days ago
Os info: All
Oracle info: 11G/12C/18c/19c
Message: Hi Team,

Is there a way to monitor all the actions performed by SYS as sysdba except login/logoff and consolidate the actions for reporting purpose?

I know it would be logged into OS level audit logs, but can we fetch the same from Database and report the same in last 24 hours?

Kindly share some light.

Thanks,
Surya
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to monitor and report SYS actions
Author: Michel Cadot, France
Date: Mar 24, 2021, 08:28, 29 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
Same answer than in your previous thread about the same question:

https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=95386

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here