-
Hi All,
I am looking to get the report for all the transactions which are happening when we are running our application in a particular time. The report should look like this
TableName :
NoOfUpdates:
NoOfInserts:
NoOfSelects:
NoOFDeletes:
I did enabled DB auditing in oracle and trying to get the information from sys.aud$, sys.dba_audit_objects and sys.audit_actions. After enabling DB auditing, The information from sys.aud$ is giving me the action name as "Session Rec" for all operations.
Please suggest me how can I give this report.
Regards,
Sekhar
-
atleast please tell me how can I resolve SessionRecn
Originally posted by Sekhar
Hi All,
I am looking to get the report for all the transactions which are happening when we are running our application in a particular time. The report should look like this
TableName :
NoOfUpdates:
NoOfInserts:
NoOfSelects:
NoOFDeletes:
I did enabled DB auditing in oracle and trying to get the information from sys.aud$, sys.dba_audit_objects and sys.audit_actions. After enabling DB auditing, The information from sys.aud$ is giving me the action name as "Session Rec" for all operations.
Please suggest me how can I give this report.
Regards,
Sekhar
-
-
-
You can use ...by access
Code:
audit delete table by scott by access;
then you get ...values of delete in ..
Code:
select action, action_name, username
from dba_audit_trail;
ACTION ACTION_NAME USERNAME
--------- --------------------------- ---------------------
103 SESSION REC RMAN
103 SESSION REC RGG
103 SESSION REC SCOTT
103 SESSION REC SCOTT
1 CREATE TABLE SCOTT
1 CREATE TABLE SCOTT
1 CREATE TABLE RGG
103 SESSION REC SCOTT
2 INSERT SCOTT
2 INSERT SCOTT
2 INSERT SCOTT
2 INSERT SCOTT
2 INSERT SCOTT
7 DELETE SCOTT
14 rows selected.
SQL>
Cheers.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|