Steps to follow to audit a DB Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Steps to follow to audit a DB

  1. #1
    Join Date
    Sep 2000



    I am looking for a detailed procedure for auditing an Oracle DB
    (detailed checklist of the point to check : DB space management, security, desgin of the DB, problems ...).

    I am also looking for a set of scripts to do that ...

    I will appreciate any helps ... I am waiting for you reply



  2. #2
    Join Date
    Jan 2001

    If the question is auditing for unauthorised access then you have to identify the tables and previledges and set up auditing accordingly. This is resorce intensive and should be done only if needed.

    As far as checking the database health check for the following;

    1. Enough free space in tablespace & Sufficient contiguous space in the tablespace to accomodate growth of large extents.
    2. List of segments approching max extent limit
    3. Monitor Fragmentation of table & index and do reorgs/rebuild index
    4. Monotor SGA for databuffer quality, SQL pin & hit ratios, buffer waits.
    5. Monitor rollback segments for header waits.
    6. Monitor system events for excessive waits.
    7. Monitor memory & disk sorts
    8. Monitor redo log buffer for excessive space requests.
    9. Identify I/O bottlenecks and do IO load balancing.

    Hope this helps.


  3. #3
    Join Date
    Feb 2000
    Washington DC

    OREILLY`s Oracle Scripts

    Buy this book and you have lots of scripts that a dba needs in day to day life. I don't say all the scripts will work, but if it doesn't work, you will make it work and customize it the way you want, as its part of your work by profession.

    If you could ask specifically the kinda script with the kinda details, probably I will provide if I have one in script library.
    you can reach me

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