Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: Impact of auditing on performance

    Hi friends,

    I am an information security student, doing research on the effects of auditing on system performance. I am currently trying to research the impact that auditing (system level & application level) may have on the performance of an Oracle 8i database.

    Any help/pointers in the right direction would be appreciated.

    Thanks in advance.
    Frodo

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Bagginsssszizz, we hates them.

    It depends on how you are auditing.

    The less intrusive method (as far as I know) is to monitor tables / indexes.

    SQL> alter table TABLE_NAME monitoring usage;

    Then after decent period of time select from v$object_usage to see results (you must be in the schema of the object being monitored to view these statistics.)

    To turn off monitoring:

    SQL> alter table TABLE_NAME NOmonitoring usage;

    This is internal to Oracle - so I don't know if it's what you are looking for but it may help?
    All monitoring will depend on your system and you would generally have to test to find meaningfull results (with and without monitoring during normal processing.)

    Again, not sure if this is what you are looking for?

    Rgs,
    Breen.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •