auditing .. urgent please
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: auditing .. urgent please

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    78
    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






  2. #2
    Join Date
    Jan 2002
    Posts
    78

    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






  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

  4. #4
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Check this also for SESSION REC

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

    HTH.

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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
  •  


Click Here to Expand Forum to Full Width