Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Posts
    10

    Question Unanswered: audit a database

    hello,
    i have the problem, that i must find the changes in my database. i mean, all the things that happen. i just read on a page in the internet, there is a way, to do that with the statement "audit".
    i have no idea what's the cost off performance and space for that command. have someone tryed this?
    it seems for me the better solution, than monitor the redo-logs. for installing that monitoring i must restart the database - thats not possible in this moment.

    Jan

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    Oracle can audit EVERYTHING:

    Auditing can be written to the sys.aud$ table or to an os file.

    Whenever you choose to record the actions to the sys.aud$ table you have got to be aware that it can grow really (and I mean realy) big.

    Of course there is a preformance gap in auditing.

    Hope this helps


    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    Dec 2002
    Posts
    10
    Originally posted by remivisser
    Auditing can be written to the sys.aud$ table or to an os file.
    to an os file? How can you configure this? i just find a way to switch "audit" on - hope there is a way to switch it off.

  4. #4
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    AUDIT_TRAIL init parameter

    You need to set the AUDIT_TRAIL parameter in your init<$ORACLE_SID>.ora file.

    This parameter can be set to one of the three following values:

    DB: enables auditing, audited records are stored in the SYS.AUD$ table.
    OS: enables auditing, audited records are written to the operating system's audit trail, onwindows it will be written to the "eventviewer"
    NONE: disables auditing. ( isdefault)

    In order for the parameter to take affect you need to restart the instance.

    Hope this helps.
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.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
  •