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

Thread: Steps to follow to audit a DB

  1. #1
    Join Date
    Sep 2000
    Posts
    64

    Smile

    Hello,

    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

    Thinks

    Sofiane
    Sofiane

  2. #2
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    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.

    Baliga


  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    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 orcl_dba@hotmail.com

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