auditing .. urgent please

[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

[Sekhar]

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

[ggnanaraj]

Check this out...

http://metalink.oracle.com/metalink/...&p_id=167293.1

http://download-west.oracle.com/docs...17EE/index.htm

[Edited by ggnanaraj on 09-04-2002 at 06:48 AM]

[ggnanaraj]

Check this also for SESSION REC

http://metalink.oracle.com/metalink/..._id=235832.995

HTH.

[ggnanaraj]

You can use ...by access

audit delete table by  scott by access;

then you get ...values of delete in ..

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.