I am interested in tracking user activity in my IFS8/Oracle 12c system. The type of information I am interested in is:
When was a module or transaction last used? Which users are using which modules or executing which programs? What are the most frequently used modules or transactions? What modules have the highest CPU usage?
When I query gv$session I can see the current users and what they are executing, but I am looking for historic data.
I know this information might be available from Oracle OEM, but due to separation of duties, I do not have access to this tool.
Page 1 / 1
In IFS there is no option to set that kind of auditing. you can set the Oracle level auditing .
ypou can follow the following Oracle documentation to get how you set that up.
As Chandana mentioned “Oracle Auditing” will address your concern.
Oracle Auditing.
Every time a user attempts anything in the database where audit is enabled the Oracle kernel checks to see if an audit record should be created or updated and generates the record in a table owned by the SYS user called AUD$. This table is, by default, located in the SYSTEM tablespace.
The following three types of audits are provide by Oracle
1. Session audits (LOGON,LOGOFF etc) 2. Database action and object audits and 3. DDL(CREATE, ALTER & DROP of objects)
To enable database auditing, you must provide a value for the AUDIT_TRAIL parameter.Auditing is disabled by default, but can enabled by setting the AUDIT_TRAIL static parameter, which has the following allowed values.
AUDIT_TRAIL = { none | os | db | db,extended | xml | xml,extended }
DB Auditing is enabled. Audit records will be written to the SYS.AUD$ table. OS Auditing is enabled. Audit records will be written to an audit trail in the operating system.
> Enable auditing and direct audit records to the database audit trail (ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE;)
You will find plenty of documentation from the internet for guidance on this.
