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.
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?