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